from io import StringIO
import pandas as pd
import requests
url = 'https://raw.githubusercontent.com/cs109/2014_data/master/countries.csv'
s = requests.get(url).text
c = pd.read_csv(StringIO(s))
Pandas read_csv from url