Python Pandas Tutorial: DataFrame Operations (Rename or Drop Column, Set, Reset, and Use Indexes) #7

In this video you will learn more about Operations on DataFrames (Rename or Drop Column, Set, Reset, and Use Indexes).
To handle the data using pandas is very easy just like in Microsoft Excel, if you are expert in Pandas DataFrame Operations. Pandas provides high-performance, easy-to-use data structures as a Series, Data Frame (Panel Data Structure) with high level of statistical operation and time series analysis.
This video tutorial will cover complete understanding of below points:
1.) Renaming Columns in a Pandas DataFrame.
2.) Explaining the Inplace Parameter for Beginners
3.) How to apply axis (rows-column) on DataFrame?
4.) Delete single or multiple column from DataFrame based on condition.
5.) Delete rows in pandas DataFrame based on condition.
6.) How to set- reset and delete DataFrame's index?
7.) Various Assignments and Operations on a DataFrame
Python Jupyter Notebook: tinyurl.com/yh9tc4mf
Source Data: tinyurl.com/ygtaqhxa
Python Teaser: • A Beautiful Python Pro...
Python Pandas Tutorial: • Python Pandas Tutorial...
Python Playlist: • Python Tutorial for Be...
Python Data Structure Playlist: • Python Data Structure
Python OOPs Playlist: • Object Oriented Progra...
Python Excel Automation: • Excel Automation Using...

[@umeshsamal165]

Nice Tutorial

[@ProgrammingIsFunn]

Glad you think so!

[@swagatkumarpanda4194]

Thank You for clearing my doubts

[@ProgrammingIsFunn]

Glad to hear!!!

[@punnarajeev867]

Sooo nice bro. keep going on....

[@ProgrammingIsFunn]

Thanks ✌️

[@datascience1036]

Very very informativeeeeeee

[@PAVANKUMAR648]

Hello Buddy, This tutorial is helping me like anything. Thank you so much for your valuable time and effort on this. I look forward to watching more videos as you upload. Also I heard a beat/music almost at the end of this video which I liked very much. I wanted to hear it using my SONY headphones. Could you please let me know which one is that? Regards, Pavan T S

[@devmaharaj4640]

Super , thanks. Please do start tutorial in Data science and ML too , if possible

[@ProgrammingIsFunn]

Sure!! We will start soon.

[@gauravkumarkashyap9353]

i have a multiple sheets in XLS with same column name. how do we delete any particular column from all the sheets ?

[@ProgrammingIsFunn]

You can locate the index of each column in the spreadsheet, save the headers into a list, determine the index accordingly, and then utilize the following line of code. sheet.range((1, column_index)).api.EntireColumn.Delete()

[@gauravkumarkashyap9353]

@@ProgrammingIsFunn let me try

[@kawaljeetkaur138]

Hello....your tutorial helped a lot but one doubt when I read excel file it's give me error "missing optional dependency openpyxl use pip or conda to install....any solution and why it's coming

[@ProgrammingIsFunn]

Thanks, if you are getting this error means you have to install openpyxl separately using pip install openpyxl