Python & Excel Data Collection Forms - Five Minute Python Scripts
Upgrade your data collection forms with Python. We'll cover how to create a basic data collection form and save the data entered back to an excel spreadsheet.
We'll use tkinter and pandas to do this.
Let me know if you have questions, comments, or recommendations for the next video! Until next time.
Kite helps fund the channel, thanks for checking them out and supporting me --
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. https://www.kite.com/get-kite/?utm_me...
THANKS SO MUCH FOR ALL THE SUPPORT!! (1,050+ SUBSCRIBERS!) Honestly speechless - Thank you everyone. Your support means so much.
The link to the GitHub code used in this tutorial:
https://github.com/Derrick-Sherrill/D...
The image used on the end screen of this video:
https://pixabay.com/photos/pug-dog-pe...
*****************************************************************
I'll start posting the full code in the description as well now too. (Let me know if you think this is a good change?)
Full Script from this video:
from tkinter import *
import pandas as pd
def submit_fields():
path = 'excel.xlsx'
df1 = pd.read_excel(path)
SeriesA = df1['Operator']
SeriesB = df1['Number']
A = pd.Series(entry1.get())
B = pd.Series(entry2.get())
SeriesA = SeriesA.append(A)
SeriesB = SeriesB.append(B)
df2 = pd.DataFrame({"Operator":SeriesA, "Number":SeriesB})
df2.to_excel(path, index=False)
entry1.delete(0, END)
entry2.delete(0, END)
master = Tk()
Label(master, text="Operator").grid(row=0)
Label(master, text="Number").grid(row=1)
entry1 = Entry(master)
entry2 = Entry(master)
entry1.grid(row=0, column=1)
entry2.grid(row=1, column=1)
Button(master, text='Quit', command=master.quit).grid(row=3,column=0, pady=4)
Button(master, text='Submit', command=submit_fields).grid(row=3,column=1, pady=4)
mainloop()
*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:
https://github.com/Derrick-Sherrill/D...
Check out my website:
https://www.derricksherrill.com/
If you liked the video - please hit the like button. It means more than you know. Thanks for watching!!
Useful Links
-----------------------------------------------------------------------------------------------------------------
Python Download:
https://www.python.org/downloads/
(Remember Python 3 is the future!)
I use Atom Text Editor for all my tutorials
Atom Text Editor:
https://atom.io/
Packages I often use in Python tutorials:
-Pandas
https://pandas.pydata.org/pandas-docs...
-Numpy
https://www.numpy.org/
-xlrd
https://xlrd.readthedocs.io/en/latest/
-TensorFlow
https://www.tensorflow.org/api_docs/p...
-Matplotlib
https://matplotlib.org/
-Django Framework
https://www.djangoproject.com/
-Beautiful Soup
https://www.crummy.com/software/Beaut...
(Install through Terminal $pip3 install ....)
Other Useful Services sometimes featured:
-Amazon Web Services (AWS)
https://aws.amazon.com/
-Microsoft Azure
https://azure.microsoft.com/en-us/
-Google Cloud
https://cloud.google.com/
-Juypter Notebooks
https://jupyter.org/
Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!
En esta página del sitio puede ver el video en línea Python & Excel Data Collection Forms - Five Minute Python Scripts de Duración hora minuto segunda en buena calidad , que subió el usuario Derrick Sherrill 11 mayo 2019, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 51,080 veces y le gustó 1.3 mil a los espectadores. Disfruta viendo!
