Read-Online-Csv
Sat 17 May 2025
title: "Read Online CSV" author: "Raja CSP Raman" date: 2019-04-20 description: "-" type: technical_note draft: false
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
Score: 5
Category: basics