Scribd
Upload
26 views1 page

Mastering Pandas: Dataframe Essentials

The document provides an overview of pandas, highlighting its advantages over Excel and plain Python for data manipulation. It covers the basics of dataframes, including creation methods, handling missing data, and performing Excel-like operations. Additionally, it discusses advanced topics such as merging, grouping, reshaping, pivot tables, time series, and plotting.

Uploaded by

nahidakram125
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
26 views1 page

Mastering Pandas: Dataframe Essentials

The document provides an overview of pandas, highlighting its advantages over Excel and plain Python for data manipulation. It covers the basics of dataframes, including creation methods, handling missing data, and performing Excel-like operations. Additionally, it discusses advanced topics such as merging, grouping, reshaping, pivot tables, time series, and plotting.

Uploaded by

nahidakram125
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

1) Intro

* what is pandas?
* what using excel/plain python not good.
* Show how pandas increase productivity

2) Dataframe basics
* What is dataframe?
* Dealing with rows and columns
* Operations: mean, max, std, describe
* Conditional selection
* set_index

3) Different ways of creating dataframe


* dictionary, tuples list, list of dictionaries, csv, excel

-) reading/writing to excel/csv: [Link]

-) Handling Missing Data


* dropna
* fillna
* isnull
* [Link]

-) Excel Like Operations


* sort
* filter
* remove/rename columns
* .duplicated
*

-) Selection of data
* df['A'] or df.A
* df[0:3]
* df['20130102':'20130104']
* [Link]['Rain'] or [Link]['Rain']
* [Link][3]
* [Link][1,1]
* df[df.A > 0]

-) Merge/Concat/Join
-) Grouping
-) Reshaping/Stack/Unstack
-) Pivot Table
-) Time Series and Categoricals
-) Plotting (Bokeh?)

You might also like