Load data from url to a dataframe

Question

I am working on a pandas tutorial and want to load the following data to a dataframe (I am using python 3.6 and pandas 0.23.0):

Data from URL

I know how to load data from the standard data formats (csv, excel, etc.) but have now clue how to handle the data at hand. (There probably is an easy solution (maybe already on SO?), but so far I found none as I don't even know what I am looking at exactly).

Thank you very much, I appreciate the quick, kind comeback!

GhostCat
– GhostCat

2018-10-04 12:53:38 +00:00
Commented Oct 4, 2018 at 12:53 — GhostCat
– GhostCat, Commented Oct 4, 2018 at 12:53

jezrael · Accepted Answer · 2018-09-25 10:04:59Z

2

Simply use read_csv, which working with url link to data very nice:

url = 'https://raw.githubusercontent.com/justmarkham/DAT8/master/data/u.user'
df = pd.read_csv(url, sep='|')
print (df.head())
   user_id  age gender  occupation zip_code
0        1   24      M  technician    85711
1        2   53      F       other    94043
2        3   23      M      writer    32067
3        4   24      M  technician    43537
4        5   33      F       other    15213

answered Sep 25, 2018 at 10:04

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jones1220 Over a year ago

Thanks, thats exactly what I was looking for!

Naga kiran · Accepted Answer · 2018-09-25 10:05:49Z

1

have you tried this

df = pd.read_csv('https://raw.githubusercontent.com/justmarkham/DAT8/master/data/u.user',sep ='|')

answered Sep 25, 2018 at 10:05

Naga kiran

4,6071 gold badge21 silver badges32 bronze badges

Collectives™ on Stack Overflow

Load data from url to a dataframe

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related