Read Online CSV

from io import BytesIO
import requests
import pandas as pd
filename = 'https://gitlab.com/rajacsp/datasets/raw/master/amazon_co_ecommerce_sample.csv'

r = requests.get(filename)
data = r.content
df = pd.read_csv(BytesIO(data), index_col=0)
df.head()
product_name manufacturer price number_available_in_stock number_of_reviews number_of_answered_questions average_review_rating amazon_category_and_sub_category customers_who_bought_this_item_also_bought description product_information product_description items_customers_buy_after_viewing_this_item customer_questions_and_answers customer_reviews sellers
uniq_id
eac7efa5dbd3d667f26eb3d3ab504464 Hornby 2014 Catalogue Hornby £3.42 5 new 15.0 1.0 4.9 out of 5 stars Hobbies > Model Trains & Railway Sets > Rail V... http://www.amazon.co.uk/Hornby-R8150-Catalogue... Product Description Hornby 2014 Catalogue Box ... Technical Details Item Weight640 g Product Dim... Product Description Hornby 2014 Catalogue Box ... http://www.amazon.co.uk/Hornby-R8150-Catalogue... Does this catalogue detail all the previous Ho... Worth Buying For The Pictures Alone (As Ever) ... {"seller"=>[{"Seller_name_1"=>"Amazon.co.uk", ...
b17540ef7e86e461d37f3ae58b7b72ac FunkyBuys® Large Christmas Holiday Express Fes... FunkyBuys £16.99 NaN 2.0 1.0 4.5 out of 5 stars Hobbies > Model Trains & Railway Sets > Rail V... http://www.amazon.co.uk/Christmas-Holiday-Expr... Size Name:Large FunkyBuys® Large Christmas Hol... Technical Details Manufacturer recommended age... Size Name:Large FunkyBuys® Large Christmas Hol... http://www.amazon.co.uk/Christmas-Holiday-Expr... can you turn off sounds // hi no you cant turn... Four Stars // 4.0 // 18 Dec. 2015 // By\n \... {"seller"=>{"Seller_name_1"=>"UHD WHOLESALE", ...
348f344247b0c1a935b1223072ef9d8a CLASSIC TOY TRAIN SET TRACK CARRIAGES LIGHT EN... ccf £9.99 2 new 17.0 2.0 3.9 out of 5 stars Hobbies > Model Trains & Railway Sets > Rail V... http://www.amazon.co.uk/Classic-Train-Lights-B... BIG CLASSIC TOY TRAIN SET TRACK CARRIAGE LIGHT... Technical Details Manufacturer recommended age... BIG CLASSIC TOY TRAIN SET TRACK CARRIAGE LIGHT... http://www.amazon.co.uk/Train-With-Tracks-Batt... What is the gauge of the track // Hi Paul.Trut... **Highly Recommended!** // 5.0 // 26 May 2015 ... {"seller"=>[{"Seller_name_1"=>"DEAL-BOX", "Sel...
e12b92dbb8eaee78b22965d2a9bbbd9f HORNBY Coach R4410A BR Hawksworth Corridor 3rd Hornby £39.99 NaN 1.0 2.0 5.0 out of 5 stars Hobbies > Model Trains & Railway Sets > Rail V... NaN Hornby 00 Gauge BR Hawksworth 3rd Class W 2107... Technical Details Item Weight259 g Product Dim... Hornby 00 Gauge BR Hawksworth 3rd Class W 2107... NaN NaN I love it // 5.0 // 22 July 2013 // By\n \n... NaN
e33a9adeed5f36840ccc227db4682a36 Hornby 00 Gauge 0-4-0 Gildenlow Salt Co. Steam... Hornby £32.19 NaN 3.0 2.0 4.7 out of 5 stars Hobbies > Model Trains & Railway Sets > Rail V... http://www.amazon.co.uk/Hornby-R6367-RailRoad-... Product Description Hornby RailRoad 0-4-0 Gild... Technical Details Item Weight159 g Product Dim... Product Description Hornby RailRoad 0-4-0 Gild... http://www.amazon.co.uk/Hornby-R2672-RailRoad-... NaN Birthday present // 5.0 // 14 April 2014 // By... NaN 
# source : https://stackoverflow.com/questions/19611729/getting-google-spreadsheet-csv-into-a-pandas-dataframe