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!
Auf dieser Seite können Sie das Online-Video Python & Excel Data Collection Forms - Five Minute Python Scripts mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Derrick Sherrill 11 Mai 2019 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 51,080 Mal angesehen und es wurde von 1.3 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
