download csv file from jupyter notebook

1import base64
2import pandas as pd
3from IPython.display import HTML
4
5def create_download_link( df, title = "Download CSV file", filename = "data.csv"):
6    csv = df.to_csv()
7    b64 = base64.b64encode(csv.encode())
8    payload = b64.decode()
9    html = '<a download="{filename}" href="data:text/csv;base64,{payload}" target="_blank">{title}</a>'
10    html = html.format(payload=payload,title=title,filename=filename)
11    return HTML(html)
12
13df = pd.DataFrame(data = [[1,2],[3,4]], columns=['Col 1', 'Col 2'])
14create_download_link(df)
15