In this Python Automation video, we are gonna be automating Form Submission such that we can submit data from an excel file or csv file or similar, regardless of the quantity, whether it be 1000, 10k or 100k. The idea is fetching data, processing data, and submit each of them into the form. We will go through three important things in this video :
1) Read/Fetch data from an excel/csv/simlar file using Pandas, the popular and loved package by Data Scientists.
2) Handling inputs such as radio input, checkbox input and select elements using Selenium.
We will leverage Python Selenium for this Automatic Form Submission in Python Automation.
Join Code Band Community❤️
WhatsApp Group Link:
Telegram Group Link:
Full Playlist : Python Web Automation | Python Selenium Tutorial | Python Automation Tutorial : https://www.youtube.com/playlist?list=PLbasZIkCgHJFbX-kU4vjXsdiHVxGsJzZT
Project Files – Github Repository : https://github.com/akjasim/python-automation-selenium (In branch 7-automatic-form-submission)
Don’t forget to give a ⭐️ to the repo.
Selenium Select Docs : https://selenium-python.readthedocs.io/navigating.html#filling-in-forms
Selenium Docs : https://selenium-python.readthedocs.io/
Subscribe | Code Band
Other videos in Code Band:
WhatsApp Automation using Python Selenium : https://www.youtube.com/watch?v=taSnpvwvgow&list=PLbasZIkCgHJFbX-kU4vjXsdiHVxGsJzZT&index=9&t=0s
Python Automation | Part 5 :Instagram Profile Fetch Automation|Python Web Automation|Python Selenium : https://youtu.be/qcTJIqtLYG0
Python Automation|Part 6 : Gmail Bulk Email Sending Automation|Python Web Automation|Python Selenium : https://youtu.be/A7ZN8JIsGwg
Build a Weather App in Django | Scrape Weather Data from Google | Beautiful Soup | Python Requests : https://youtu.be/-gzUIPyBRJg
Python Interview Questions | Python Tricks | Python Tricky Programs | Python Tricks and Hacks : https://youtu.be/I2BAScqkWMU
Python .env File | Django .env File Example | Python Decouple Django | Django Environment Variables : https://youtu.be/myqfTX9ZbTs
Django Autocomplete with jQuery UI | AJAX | Search | Filter from Database | Tutorial | Code Band : https://youtu.be/-oLVZp1NQVE
Django Dependent Drop Down List Example | Integration with Django Forms and Django Form Validations : https://youtu.be/LmYDXgYK1so
Django Select2 Tutorial | Django Dropdown | Django ajax Dropdown | Django Search and Filter : https://youtu.be/8VYx-cNF1lU
Django Shell Plus | Advanced Django Shell | Django Shell Commands | Django Shell Tutorial : https://youtu.be/kNFMpfek4Ic
Django Seed Data into Database Models | Django Faker | Django loaddata | Django Dummy Data : https://youtu.be/QUXvqfN1ENM
3 Cool Django Features that Django Developers are Not Aware of : https://youtu.be/ljfeFx6QJOM
Django Custom User Model | Email as Username | Phone as Username | Authentication Example |Code Band : https://youtu.be/SbU2wdPIcaY
Playlist | Django Authentication | The easiest and actual way of doing it : https://www.youtube.com/playlist?list=PLbasZIkCgHJEQkL2pKTstb4JGrGO6SF9R
Playlist | Django Relationships | Explained with Example by Code Band : https://www.youtube.com/playlist?list=PLbasZIkCgHJH38p2WkC5GTsgoV_8hlQ4A
Custom Model Manager & Model QuerySet in Django : https://youtu.be/zQpYokJN34s
Render Django Form Manually : Make Custom Form with Form Validations – https://youtu.be/PMRalI2M3SY
Generic Class Based Views in Django | Introduction & Create View in Django | Learn by Example | CRUD : https://youtu.be/RBKjarWdUq4
How to Deploy Django Project on Heroku for Free : https://youtu.be/V2rWvStauak
Connect Django with MySQL : https://youtu.be/RCbRjacna20
Instagram Automation using Python : https://youtu.be/5pIqwVSNzX4
Top 5 Programming Languages to Learn in 2020 : https://youtu.be/WM0WCMpYCx0
🙂 You Can Find Me On:
My Website – https://jasim.tech/
Linkedin – https://in.linkedin.com/in/akjasim
Github – https://github.com/akjasim/
Facebook – https://www.facebook.com/jasimakjasim
Twitter – https://twitter.com/akjasim
Instagram – https://www.instagram.com/jasim_ak/
Please pin me
Thanks for share your knowledge, I'm having an issue entering numbers from an excel.
Python is giving me this error "object of type 'numpy.int64' has no len() ", I google it and it telling me that is error happend when you try to add types such as integer, float, boolean, long, complex.
What other fuction can I use in this case?
Hai sir, ur video super. I learn so much ur channel. I have one this video I try read data is work. I want write data for excel can plz send format for write data in pandas
Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.
Hi Code Band,
Need your help to find Combo Box and entering the value .Can you please help me on this
My code is filling the form for the first time only after that the program just stops. How do I fix this ?
I want to reload form after first entry submitted and after that fill second entry .
Thank you so much ❤
that 2nd way to submit was really helpful for me
3:58–4:05 You said that it has been already discussed it's simple. please share the link of the discussion, I need that
Thank you very much!!!
Congrats!!! Like DONE – Subscribe Super DONE
This a great video. It seems that the xpath for choosing radio button is not working when used in MS Forms. I tried it and it just skips the radio button question for me. Do you have any alternative way to choose a radio button based on MS Forms? Thanks!
This video is very helpful for web automation. Thank you
thanks a lot
Can you please help me on how to fire a website using single sign on.. because as soon as the website detects that chrome is being controlled by automation test software it does not allow access.
or i in range(len(val)):
TypeError: object of type 'numpy.int64' has no len() how to fix this
Hey bro when it’s a number it doesn’t type it any idea how to fix it
How can we edit the script to run so that it automatically fills out the patient information only after inputting the the first form.
really helped me a lot.
bro, not able to click or select the checkbox
else everything is fine
Have you ever explained in any of your video that how can we scrap the values from the Web and fills back the values in excel for a particular row, then plss refer your tutorial or make a tutorial, it would be really helpful. Thank you ❤️❤️
Hey just wanna thank you for this precious knowledge. I have a question, that what if the script brokes somehow in between for any particular row data of excel, how can we tackle this thing and continue our script for other row data or index?
keep going bro..
addicted to the web automation playlist 😍😍
awesome as always bro