/Python/How to read csv file online into pandas

How to read csv file online into pandas

Read a csv file in pandas

you should be in the same dir as .py file 

df = pd.read_csv('your_file_name.csv')

How to read csv file online into pandas

import pandas as pd
import io
import requests
url="https://raw.githubusercontent.com/cs109/2014_data/master/countries.csv"
s=requests.get(url).content
c=pd.read_csv(io.StringIO(s.decode('utf-8')))

Source: stackoverflow.com

Similar codes

3 votes373 views2 answers
Rest_framework_simplejwt
Python
0 vote387 views1 answer
Django pointfield value format for fixtures
Python Django
1 vote330 views1 answer
Jupyter notebook how to set max display row columns matrix numpy
Python
10 votes337 views1 answer
How to add legend to python plot
Python
0 vote404 views1 answer
How to add new column in django
Python Django
22 votes350 views8 answers
Math
Python
0 vote339 views1 answer
Python class overwrite length method
Python
3 votes354 views1 answer
Jinja2 datetime format
Python
1 vote353 views4 answers
Numpy count occurrences in array
Python
0 vote305 views1 answer
Python how to hash string into pbkdf2
Python