How to Create an Excel Web App | Intro to Streamlit

Подписаться 19 тыс.

Просмотров 20 тыс.

50% 1

Learn how to create an excel web app using Streamlit. Follow and code with me with this step by step tutorial
Link on GitHub: github.com/satssehgal/realest...
Machine Learning with Regression - • Introduction to Machin...
Machine Learning Follow Up - • Introduction to Machin...
Machine Learning with Neural Network - • Introduction to Machin...
Code and instructions are available on github for learning and following along 👉🏼 github.com/satssehgal/realest...
👉 Patreon: patreon.com/SATSifaction
👉 Facebook Group: / theaiwarriors
👉 Instagram: @theaiwarriors
👉 Corporate Training and Up skilling: levers.ai
Netfirms (Affiliate) - bit.ly/2KdJ4Dp
Linode Server - bit.ly/2XpqGi9
Bluehost (Affiliate) - bit.ly/2GxxBh1
PythonAnywhere (Affiliate) - bit.ly/2kWORVe
Heroku - www.heroku.co
NordVPN (Affiliate) - bit.ly/2W87je0
✅ Here is a link to my python for beginners, master python course: bit.ly/2HIZS42

Кино

Опубликовано:

24 авг 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 27

@SuhasPassionated 3 года назад

Covered multiple concepts in 8 mins. Thanks!

@aikanshivaish4584 2 года назад

SO nice explanation in short span of time, appreciate it.

@SATSifaction 2 года назад

You’re very welcome

@steelraider94 3 года назад

Awesome work my dude.

@barraganroberto 3 года назад

Awesome tutorial! Thanks! :)

@SATSifaction 3 года назад

you're welcome

@14jabin 3 года назад

Nice tutorial ✌️

@udayposia5069 3 года назад

You are a genius!!

@Vagabondion 3 года назад

Noice! Gonna try it for demand planning.

@SATSifaction 3 года назад

great

@n.w.4940 3 года назад

Really awesome tutorial!

@SATSifaction 3 года назад

Thanks

@DequanHarrison 3 года назад

Excellent! Thanks!

@SATSifaction 3 года назад

you're welcome

@issabarack8590 3 года назад

Very interesting video

@and_ppv 3 года назад

Brilliant

@oscarmartinezbeltran 3 года назад

Hi Sath, Do you think is Streamlit the death for JS, Flask, Django etc? it looks like Streamlit is going to make all of them redundant. Sugestion: make more Streamlit tutorials. Thanks!

@SATSifaction 3 года назад

no its not the death of either, its another complimentary framework. Thats all

@qarampage8056 3 года назад

Great stuff .. thanks. Hey is there a way to hide the python file code that we use in excel using xlwings?

@SATSifaction 3 года назад

there is no elegant way to do this...

@jarosaw4013 Год назад

Greta!

@mrbirgaming2384 3 года назад

What will be the code for downloading data in form of excel file

@CodingIsFun 3 года назад

The following function takes a pandas dataframe as an input & returns a download link (Excel file): import base64 # Standard Python Module from io import StringIO, BytesIO # Standard Python Module def generate_excel_download_link(df): # Credit: discuss.streamlit.io/t/how-to-add-a-download-excel-csv-function-to-a-button/4474/5 towrite = BytesIO() df.to_excel(towrite, encoding="utf-8", index=False, header=True) # write to BytesIO buffer towrite.seek(0) # reset pointer b64 = base64.b64encode(towrite.read()).decode() href = f'Download Excel File' return st.markdown(href, unsafe_allow_html=True) Hope it helps.

@imranmasoud1849 3 года назад

All I need is to show my excel data table and be able to use that sidebar. Can someone please help me?

@CodingIsFun 3 года назад

Hi there, here an example for you: import pandas as pd import streamlit as st st.set_page_config(page_title='My Excel App') st.header('My Excel App') st.subheader('This is how my Excel Data looks like:') excel_file = 'NAME_OF_YOUR_EXCEL_FILE.xlsx' df = pd.read_excel(excel_file) add_selectbox = st.sidebar.selectbox( "How would you like to be contacted?", ("Email", "Home phone", "Mobile phone") ) st.dataframe(df) Hope it helps 😃

@imranmasoud1849 3 года назад

@@CodingIsFun thank you so much youre amazing! I actually follow your channel and this is why, you are the most helpful coder on youtube!!!

@CodingIsFun 3 года назад

@@imranmasoud1849 Thank you for your kind words. Glad it was helpful 😃