Dive into a comprehensive tutorial series on the Pandas library for Python data manipulation and analysis. Learn to install Pandas, read CSV files, handle null values using various methods, create DataFrames, and apply essential functions like describe(), shape(), ffill(), fillna(), and replace(). Master data manipulation techniques including the use of query(), insert(), cumsum(), and sample() functions. Explore advanced concepts such as row and column-wise operations, statistical functions like covariance and correlation, and time series analysis with rolling() and expanding() functions. Gain proficiency in data reshaping using melt() and pivot() functions, and optimize your code with memory usage analysis. Through hands-on examples with real datasets, develop the skills to efficiently process, clean, and analyze data using Pandas.
Overview
Syllabus
Pandas Tutorial Part:01 | What is Pandas | how to install pandas | pandas installation in windows.
Pandas Tutorial Part:02 | Read data using pandas | how to read csv data | read csv data using pandas.
Pandas Tutorial Part:03 | Describe function | Shape function | Checking null values using pandas.
Pandas Tutorial Part:04 | Filling null values | ffill function | Fillna function | Null values.
Pandas Tutorial Part:05 | Filling null values | replace function | Null values in pandas.
Pandas Tutorial Part:06 | Filling null values | Interpolate function | Null values in pandas.
Pandas Tutorial Part:07 | Making dataframe using numpy pandas | query function | python pandas.
Pandas Tutorial Part:08 | Insert function | cumsum function | sample function | python pandas.
Pandas Tutorial Part:09 | isin function | loc and iloc function |rank function | python pandas.
Pandas Tutorial Part:10 | row and column wise function application| mean function | python pandas.
Pandas Tutorial Part:11 | covariance function | statistical function using pandas | python pandas.
Pandas Tutorial Part:12 | correlation function | statistical function using pandas | python pandas.
Pandas Tutorial Part:13 | .rolling() function | statistical function using pandas | python pandas.
Pandas Tutorial Part:14 | .expanding() function | statistical function using pandas | python pandas.
Pandas Tutorial Part:15 | .melt() function | statistical function using pandas | python pandas.
Pandas Tutorial Part:16 pivot() function | statistical function using pandas | python pandas.
Pandas Tutorial Part:17 nunique() function | statistical function using pandas | python pandas.
Pandas Tutorial Part:18 memory usage() function | statistical function using pandas | python pandas.
Pandas Tutorial Part:19 select datatypes function and replace | pandas | python pandas.
Pandas Tutorial Part:20 nsmallest and nlargest functions | pandas | python pandas.
Taught by
FUN WITH DATA SCIENCE
