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 --

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:

The image used on the end screen of this video:

*****************************************************************
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():
SeriesA = df1['Operator']
SeriesB = df1['Number']
SeriesA = SeriesA.append(A)
SeriesB = SeriesB.append(B)
df2 = pd.DataFrame({"Operator":SeriesA, "Number":SeriesB})

master = Tk()

Label(master, text="Operator").grid(row=0)
Label(master, text="Number").grid(row=1)

entry1 = Entry(master)
entry2 = Entry(master)

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:

Check out my website:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching!!

Useful Links
-----------------------------------------------------------------------------------------------------------------
Python Download:
(Remember Python 3 is the future!)

I use Atom Text Editor for all my tutorials
Atom Text Editor:

Packages I often use in Python tutorials:
-Pandas
-Numpy
-xlrd
-TensorFlow
-Matplotlib
-Django Framework
-Beautiful Soup
(Install through Terminal $pip3 install ....)

Other Useful Services sometimes featured:
-Amazon Web Services (AWS)
-Microsoft Azure
-Google Cloud
-Juypter Notebooks

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

[dexterasis]

Of all the videos i watched on how to work with pandas and write another row to what I already have, yours was the only freaking one that worked. Thank you.

[derekjp]

Using this as a part of a program I'm writing to gather data on stocks and compile it for me into a master excel file. Really well done video that is going to help me a Ton. TY! Subbed for sure.

[mlkabir]

Awesome video, right to action. Though this is first video of I've watched by Derrick, Already become a fan. Will see other videos of yours.

[KostasPanagias]

Excellent video! Very useful! Thank you Derrick

[mvlog]

That's huge work. I wonder why someone would need Python to do this simple task in excel.

[loveSG]

Great video! More of these examples with tkinter please 👍

[durgam_sumerian]

Wow, i thought it's just another one of these short crap programming videos. But yours is very useful and awesome..thanks and cheers from iraq.

[scochran]

Awesome... Short and to the point. This I can put to good use. Very informative.

[oghot]

New subscriber from Nigeria. Very rich content you've got!


Quick question, can I run TKinter in a Jupyter Notebook or does it have to be in an IDE?

[fogviii]

Thank you sir, this was very useful for my finals exam 👍🏿

[rolanossi]

Great video Derrick, thank you.
But how can we update an excel row instead of add a new row?

[SiHodgy]

Derrick, any idea how to split values of random quantity and add additional columns? Say if some pc’s have two ip’s some have 4 separated by comma

[gee_rex]

yo this video has helped me alot. thanks dude

[charlespalmerii]

Kudos, good job, big help, for me who is just getting into it but has work requirement that this helps with !

[sureshvinayaka]

I like your videos Derrick, Good Job Bro..

[AverageatMostThings]

Great tutorial it was super helpful! How would I change the title of the widget? Mine says tk but I want to change it.

[patrickneeds]

This is super helpful for Mac users as the form function in excel is not available for the Mac

[maikunthaung]

great and amazing video. thank you for sharing

[sarodriguezsalcedo]

Thanks Derrick, do you know how to do the same thing but with an online-shared google spreadsheet?

[Linuxovert]

God bless you
in Arabic ..
بارك الله فيك