Export dataframe to pdf file

Using Streamlit
,
1

I want to export dashboard to pdf file but I don’t know how to do it.
How to export dataframe to pdf file?
, please help

This is my code :

> def top_five_ciff():
>     sql = """   select * from Table
>                 """
>     cur.execute(sql)
>     data = cur.fetchall()
>     return data
> 
> result = top_five_ciff()
> clean_db = pd.DataFrame(result,columns=["A","B","C","D","E"])
> st.table(clean_db)
> 
> def create_download_link(val, filename):
>     b64 = base64.b64encode(val)  
>     return  f ' < a href="data:application/octet-stream;base64,{b64.decode()}" download="{filename}.pdf">Download file</a> '
> 
> pdf = FPDF()
> pdf.add_page()
> #find function to export dashboard as pdf <<<< This line I don't know how to do it
> 
> download_link = st.table(clean_db)
> html = create_download_link(pdf.output(dest="S").encode("UTF-8"), "my_file")
> download_link.markdown(html, unsafe_allow_html=True)

image

1 Like