Python Automation | Part 10 : Automatic Form Submission using Python |Python Selenium Web Automation

    19
    24



    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.
    3) Executing JavaScript in Selenium.
    We will leverage Python Selenium for this Automatic Form Submission in Python Automation.

    Join Code Band Community❤️
    WhatsApp Group Link:
    https://lnkd.in/gJ-rrrz

    Telegram Group Link:
    https://t.me/codebandcommunity

    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.

    References :
    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/

    source

    Previous articleAWS Boto3 – Configuring Access key & Secret Access key
    Next articleProven Approach to Migrate Hadoop Data to Azure Data Services

    24 COMMENTS

    1. Hi there,
      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?

      Kind regards!

    2. 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!

    3. 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?