No video

Python & Excel Data Collection Forms - Five Minute Python Scripts

  Рет қаралды 50,601

Derrick Sherrill

Derrick Sherrill

Күн бұрын

Пікірлер: 77
@dexterasis1004
@dexterasis1004 3 жыл бұрын
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.
@mvlog5191
@mvlog5191 2 жыл бұрын
That's huge work. I wonder why someone would need Python to do this simple task in excel.
@derekjp6043
@derekjp6043 3 жыл бұрын
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.
@mlkabir12
@mlkabir12 3 жыл бұрын
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.
@durgam_sumerian7815
@durgam_sumerian7815 4 жыл бұрын
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.
@loveSG999
@loveSG999 3 жыл бұрын
Great video! More of these examples with tkinter please 👍
@fogviii
@fogviii 2 жыл бұрын
Thank you sir, this was very useful for my finals exam 👍🏿
@KostasPanagias
@KostasPanagias 5 жыл бұрын
Excellent video! Very useful! Thank you Derrick
@scochran3265
@scochran3265 4 жыл бұрын
Awesome... Short and to the point. This I can put to good use. Very informative.
@patrickneeds1297
@patrickneeds1297 2 жыл бұрын
This is super helpful for Mac users as the form function in excel is not available for the Mac
@anawerena5396
@anawerena5396 2 жыл бұрын
Great video! Thank you
@og2hot
@og2hot 5 жыл бұрын
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?
@gee_rex
@gee_rex 3 жыл бұрын
yo this video has helped me alot. thanks dude
@charlespalmerii4299
@charlespalmerii4299 3 жыл бұрын
Kudos, good job, big help, for me who is just getting into it but has work requirement that this helps with !
@ayb_htb
@ayb_htb 4 жыл бұрын
Great Video! Thank you Derrick.
@rolanossi3275
@rolanossi3275 3 жыл бұрын
Great video Derrick, thank you. But how can we update an excel row instead of add a new row?
@SiHodgy
@SiHodgy 4 жыл бұрын
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
@gopubalu1542
@gopubalu1542 3 жыл бұрын
you are too good
@umeshagarwal4271
@umeshagarwal4271 5 жыл бұрын
Hi Derrick, nice video👍
@Linuxovert
@Linuxovert 4 жыл бұрын
God bless you in Arabic .. بارك الله فيك
@maikunthaung4136
@maikunthaung4136 3 жыл бұрын
great and amazing video. thank you for sharing
@sherakhela4044
@sherakhela4044 2 жыл бұрын
Great. Thanks
@sureshvinayaka2963
@sureshvinayaka2963 4 жыл бұрын
I like your videos Derrick, Good Job Bro..
@Cloud4GreenTechnologies
@Cloud4GreenTechnologies 4 жыл бұрын
Awesome brother, very knowlegdable
@tomecsek3595
@tomecsek3595 3 жыл бұрын
great content but can you maybe make a video how to share this also with non-Python users? I´ve tried to make an .exe file but it crashes for some reason....thx
@mypalsdontcallme
@mypalsdontcallme 2 жыл бұрын
How do you go the other have a prompt where it asks for the username and then sorts through the excel spreadsheets for predetermined information?
@AverageatMostThings
@AverageatMostThings 3 жыл бұрын
Great tutorial it was super helpful! How would I change the title of the widget? Mine says tk but I want to change it.
@Prodigalzson
@Prodigalzson 4 жыл бұрын
Thank you. This is great!!
@BrendanMetcalfe
@BrendanMetcalfe 5 жыл бұрын
Great vid!
@engmoneermusa4470
@engmoneermusa4470 4 жыл бұрын
Thanks We need more like this video
@lauramog9
@lauramog9 5 жыл бұрын
Nice! thanks
@geodatacenter
@geodatacenter 4 жыл бұрын
Congratulations for your videos. I follow always . if possible to make a full formal desktop application with menu, graphic, forms, sqllite, etc. And a .Exe as product for distribution???
@geodatacenter
@geodatacenter 4 жыл бұрын
Tkinter of course
@Lucas_giming
@Lucas_giming 4 жыл бұрын
Your file path is just the file name + extension. Does that file need to be stored somewhere specific for the code to find it, or can you define the file path as a full file path? Also, would you be able to define a path to a file that is stored on a sharepoint site?
@zainzaini4211
@zainzaini4211 3 жыл бұрын
How about the other way around ? i want to create a multiple notice letter generator based on data from the excel file and then save the letter as pdf
@amitgoswami3875
@amitgoswami3875 4 жыл бұрын
Excellent, could we have MS access like features in python,
@amitgoswami3875
@amitgoswami3875 4 жыл бұрын
My motive is to remove MS access and use python as a database
@sarodriguezsalcedo3850
@sarodriguezsalcedo3850 3 жыл бұрын
Thanks Derrick, do you know how to do the same thing but with an online-shared google spreadsheet?
@tascode
@tascode 4 жыл бұрын
you are so helpfull!!! tnx mate
@user-fs8fe3qx1x
@user-fs8fe3qx1x 5 жыл бұрын
Great job!
@rakesharalikatti9295
@rakesharalikatti9295 3 жыл бұрын
Tq for it... But I wanted to create an New sheet and then insert values followed with sum of those values row wise and have printout option to get hardcopy of print. Plz can u help me
@jn14624
@jn14624 4 жыл бұрын
Thank you Derrick. However, I've got an exception when I try to enter a new record, after submitting the first one? Any ideas?
@granand
@granand 3 жыл бұрын
Hey Derrick, quite useful, can we implement CRUD rights with database integration ? 2. How can we deploy for team ? Do we need to use Flask or Django? I need to make life easy for users many and many with various systems like Mac, Windows etc and they do not have to install python..
@ChrisW-mn4zw
@ChrisW-mn4zw 3 жыл бұрын
I got invalid syntax which pointed to the last line mainloop(). Any ideas what's causing it?
@umeshagarwal4271
@umeshagarwal4271 5 жыл бұрын
Could u pls suggest, is it a good idea to make HRM( employee related) website on django? or PHP + react would be better?
@robertcliffort2354
@robertcliffort2354 2 жыл бұрын
great.
@nirmalkumar8129348683
@nirmalkumar8129348683 4 жыл бұрын
great one
@flashliqu
@flashliqu 5 жыл бұрын
Which code editor re you using on the video
@CodeWithDerrick
@CodeWithDerrick 5 жыл бұрын
Atom text editor! It’s linked in the description
@achyarfauzan4880
@achyarfauzan4880 2 жыл бұрын
thanks sir
@amauta5
@amauta5 4 жыл бұрын
Well done, bro. But... why you gotta stare into my soul? I'm just trying to learn some form making.
@fletcherabdiel1755
@fletcherabdiel1755 3 жыл бұрын
i guess it's quite off topic but does anyone know a good site to watch new movies online ?
@keagansilas2259
@keagansilas2259 3 жыл бұрын
@Fletcher Abdiel i watch on Flixzone. You can find it by googling =)
@kelvinremmy9076
@kelvinremmy9076 4 жыл бұрын
I want to path a numerical value, not text value, because there are some codes i added to calculate the data entere, but data type is not numerical... Please help
@halha5678
@halha5678 4 жыл бұрын
Great help thanks !! include comments in your code to explain better and explain the purpose of functions, methods, and others when you write your code
@sridevig4608
@sridevig4608 4 жыл бұрын
how to use the input from form as an input for a different program in another or same python file, instead of saving in a excel file? Please help
@mukelabaimate1187
@mukelabaimate1187 4 жыл бұрын
Hey thanks for the video I have tonnes of questions....
@momodoubjallow2585
@momodoubjallow2585 4 жыл бұрын
hi great video. would you mind to show how to write a similar script that is usable mobile phone to collect data in remote (without internet) hard to reach areas
@gee_rex
@gee_rex 3 жыл бұрын
hey Derrick, i created a search button, how do i code the button to function for one click only?
@fb64578
@fb64578 5 жыл бұрын
Does the codes work on a Jupyter notebook. I tried but it does not work. pls advise.
@pankjava
@pankjava 4 жыл бұрын
i want to write data into existing xls 2003 format file.... with python...
@metomeid1693
@metomeid1693 2 жыл бұрын
thanks...
@fifyfarisha9851
@fifyfarisha9851 3 жыл бұрын
where can i get the user interface?
@litttlemooncream5049
@litttlemooncream5049 3 жыл бұрын
Thx
@StudyPoint-fr2so
@StudyPoint-fr2so 4 жыл бұрын
Unable to import 'pandas'pylint(import-error) please help how to fix it
@pankjava
@pankjava 4 жыл бұрын
write "pip install pandas " into cmd
@surffahren
@surffahren 3 жыл бұрын
How to create a boolean entry?
@hamrozjumaev
@hamrozjumaev 4 жыл бұрын
while running PermissionError: [Errno 13] Permission denied: 'file.xlsx' accrued. Could you please assist with it
@svenbo8459
@svenbo8459 4 жыл бұрын
Close the workbook before running the code & it give another try
@daneshpatel5638
@daneshpatel5638 3 жыл бұрын
Hii bro When I am submitting form ....error occurs 'permission denied' can u please help me
@RaviS-vm7ux
@RaviS-vm7ux 2 жыл бұрын
Close The File and execute Again Sure u Will Get it
@mukelabaimate1187
@mukelabaimate1187 4 жыл бұрын
Want to learn Python Programming while I am at Create a Database that produces Reports
@VOKTAMIL
@VOKTAMIL 4 жыл бұрын
how to install pandas -
@kingofthecastle340
@kingofthecastle340 3 жыл бұрын
WTF????? Lol
Introducing Python in Excel
19:01
Leila Gharani
Рет қаралды 1,5 МЛН
Just Give me my Money!
00:18
GL Show Russian
Рет қаралды 585 М.
Bony Just Wants To Take A Shower #animation
00:10
GREEN MAX
Рет қаралды 7 МЛН
Violet Beauregarde Doll🫐
00:58
PIRANKA
Рет қаралды 38 МЛН
Replace Excel Vlookup with Python - Five Minute Python Scripts
6:33
Derrick Sherrill
Рет қаралды 228 М.
Top 18 Most Useful Python Modules
10:50
Tech With Tim
Рет қаралды 928 М.
Learn Python Pandas #2 - Data Selection, Viewing, & Indexing
9:14
Derrick Sherrill
Рет қаралды 25 М.
Build a Tableau COVID-19 Dashboard
23:44
Anthony Smoak
Рет қаралды 129 М.