import pandas as pd url='https://drive.google.com/file/d/0B6GhBwm5vaB2ekdlZW5WZnppb28/view?usp=sharing' url='https://drive.google.com/uc?id=' + url.split('/')[-2] df = pd.read_csv(url)