Python Excel Automation | Split the Excel Data using Python Pandas

About: Overview of Python Excel Automation | Split the Excel Data using Python Pandas
In this video you will learn how to split the data based on excel column name using python pandas. I have used an OS module to get the location of desktop or files and numpy for generating the random numbers. Pandas is basically for storing and processing the data. You can download the sample data by below link.

If you have any question on this please feel free to contact me using comment.

I will be glad if you really like this video.

To motivate me, You can share this video with your friends and colleagues and subscribe my channel.

Thanks for Watching!!!. I will see you again. :)

[poojakumari-huwd]

Really nice Nd very helpful 👍 . Thanks

[testsample]

Really, Pandas is very feasible for excel automation and data transformation

[sumitkumarroy]

Sir that was really helpful . Sir how can we split large excel file into small files using python?

[ashishmohan]

Good one sir and covered very imp topic but if possible can you please share with us excel data which u used for this

[VerticalBase]

How do I group data into different sheets automatically as soon as input is received from user?

[ImBatmanYT_CODM]

Hi there, this is probably the closest video I could find related to the problem statement I'm having right now. It goes like-
"I'm trying to pick random samples from a CSV file. The sampling logic is predefined, let's just say 10% of the entire data. We have unique users against every sample, and I want those 10% of the samples to cover every unique users. After having these 10% of unique samples, I'm further trying to assign them to unique external users, also I'm trying to automate the entire thing and trying to summaries the entire steps in CSV file as an output."

Could you help? Thank you for your time!! <3

[NRAJ]

if you can please provide code alongwith sample data please