Answers for "how to download dataframe as csv from jupyter notebook"

how to import data from csv to jupyter notebook

pd.read_csv('file_name',encoding = "utf-8")

download dataframe as csv

df.to_csv(r'Path where you want to store the exported CSV fileFile Name.csv')

download csv file from jupyter notebook

import base64
import pandas as pd
from IPython.display import HTML

def create_download_link( df, title = "Download CSV file", filename = "data.csv"):
    csv = df.to_csv()
    b64 = base64.b64encode(csv.encode())
    payload = b64.decode()
    html = '<a download="{filename}" href="data:text/csv;base64,{payload}" target="_blank">{title}</a>'
    html = html.format(payload=payload,title=title,filename=filename)
    return HTML(html)

df = pd.DataFrame(data = [[1,2],[3,4]], columns=['Col 1', 'Col 2'])
create_download_link(df)