8-1 Python Excel Automation | Python Pandas Filter Data, Delete Rows with Conditions, Add New Column

Add New Column Age
#pythonpandas
#pythonexcelautomation
#pandasfilterdatabycondition
#pandasdeleterowsbycondtion
#pandasaddnewcolumn
#excelautomation

This is a long video but there are too many things you will learn about excel automation using Python Pandas. How to Automate Excel No Macro is involved here it is in python excel automation
Pandas is very powerful library of PYTHON programming language used for data science, artificial intelligence and machine learning coding as well. Select few columns from a large file and write data to new excel. Python Excel Automation - How to filter required data from a excel file. Python Pandas How to delete unwanted rows from excel. Excel Automation How to replace values in the data columns, or clean the column values. Excel Automation with Python - How to calculate age from a date column. How to add new columns with numeric condition and text condition. How to fill blank values in a data column in Excel

There are many other tools which are used for excel automation like you can automate excel activities using vb macros, excel macros are being used from long years it you can write excl macros to filter data , you can write excel macros to delete rows with conditions , and macros can be used to add new columns and to do various other excel automation task

But when you do the excel automation using python there is one more benefit that the library which we use for excel automation in python is Pandas.

Pandas is very useful for doing many other data related and data science related works
Basics of Data Science and Machine Learning starts from Pandas so if you are learning about excel automation using pandas then it will help you further

Learn Python - Python Tutorials - Python for Beginners

[krishnakeshav]

YES.... MOST OF COMMON USGAGET ARE COVRED ... THANK YOU FOR GIVING SO LONG TIME FOR HELPING PEOPLE

[RohitPatil-kbup]

Fantastic job friend....Looking for such long time such kind of videos

[saurabhsoni]

thank you so much sir, , , for making this video, ,
love your explaination. <3

[kamakshioberoi]

Hi, Very helpful video, just wanted to know if i want to apply all the functions like filtering, delete, v-lookup in the same file and have only one output file. How am i supposed to do it? like for every new function you made a new output file ...i want one

[goodhousekeeping]

Hi in this if we wanted to save all csv in seprate dfs can you guide for that

[_mehuljadhav]

How can I filter a date column which are having 3 different dates in different different cells?

[dhanyajayaprakash]

Hi do you know how to check a particular value in a column as filter and if the search value is not present in the column then i will be a copying the new row with the data from another excel? I will be passing the filter condition for filtering the column im not sure how to achieve this data

[deepakremesh]

How can we set read excel name as to excel name dynamically

[PrabhatKumar-nrys]

Thanks for tutorial, I need to delete multiple rows from multiple columns ...like you have deleted France I need to delete multiple country ...how I can do that help

[vesa-matti]

Hello!

Awesome content!

Do you know how to skip rows with Pandas before doing something?

I’ve an excel file that contains two rows that I need to skip and then there’s columns headers in the row 3. And then from the row 4 starts all the data.

[dipanshunautiyal]

hey i have to remove some rows which have red background in excel. how can i do that??

[deepakremesh]

i want to set my read_excel name(eg: pd.read_excel('deepak.xlsx', ) to df.to_csv name (eg: 'deepak.csv'). now i am doing this manually and there is lots of excel file to do, how can i set this as dynamic.

[deepakremesh]

How can i delete all rows if found string or special character in a particular column

[_mehuljadhav]

How to Convert XLSX to CSV without losing values from formulas using python