Pandas read csv from url

Pandas go through csv file

data = pd.read_csv(
    "data/files/complex_data_example.tsv",      # relative python path to subdirectory
    sep='\t'           # Tab-separated value file.
    quotechar="'",        # single quote allowed as quote character
    dtype={"salary": int},             # Parse the salary column as an integer 
    usecols=['name', 'birth_date', 'salary'].   # Only load the three columns specified.
    parse_dates=['birth_date'],     # Intepret the birth_date column as a date
    skiprows=10,         # Skip the first 10 rows of the file
    na_values=['.', '??']       # Take any '.' or '??' values as NA
)

Source: shanelynn.ie

Pandas read csv from url

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

1 vote241 views1 answer
Next iteration python
Python
0 vote221 views1 answer
Javascript parse url with values and anchors
Python
-3 votes189 views2 answers
Multiplication table python
Python
0 vote187 views5 answers
Fancier Output Formatting in python
Python
0 vote200 views1 answer
Copyfile pyhon
Python
86 votes169 views3 answers
Install python 3.8 linux
Python
35 votes188 views6 answers
For in range loop python
Python
27 votes139 views2 answers
Get user from mention discord.py
Python
2 votes178 views2 answers
Area of trapezium
Python
1 vote202 views1 answer
No handles with labels found to put in legend
Python