python open file csv from url code example
Example 1: open csv from url python
import requests
from contextlib import closing
import csv
url = "http://samplecsvs.s3.amazonaws.com/SalesJan2009.csv"
with closing(requests.get(url, stream=True)) as r:
f = (line.decode('utf-8') for line in r.iter_lines())
reader = csv.reader(f, delimiter=',', quotechar='"')
for row in reader:
print(row)
Example 2: open csv from url python
import pandas as pd
url = "http://samplecsvs.s3.amazonaws.com/SalesJan2009.csv"
df = pd.read_csv(url)
print(df.head())