PANDAS Programming, For Beginners, Quick Start Guide: Pandas Language Crash Course Tutorial & Exercises

This is a zero-risk investment. If you are not satisfied with this eBook, you can get back the full refund within 7 days.

About This Book

Absolutely for Beginners
“Pandas Programming & Exercises” covers all essential Pandas knowledge. You can learn complete primary skills of Pandas fast and easily. The book includes many practical examples for beginners and includes exercises for the college exam, the engineer certification exam, and the job interview exam.

Prerequisite to Learn Pandas
Before learning the Pandas, you should have basic knowledge of Python and the array, because Pandas works with Python and arrays.

Table of Contents

Chapter 1
What is Pandas?
What Panda Is Used For?
Install Pandas
Set Up Python Editor
Import Pandas
Import Pandas Alias
Series
Access Series
Create a Label
Key/Value Series
Access Series by Key

Chapter 2
DataFrame
Locate the Row (1)
Locate the Row (2)
Set Up Index
Locate the Index
Data File
Read CSV File (1)
Read CSV File (2)
Create a Json File
Read Json File
Create a Python Dictionary
Read Python Dictionary

Chapter 3
Embed Python Dictionary
Print the First 5 Rows
Specified Rows from Head
Print the Last 5 Rows
Specified Rows from Tail
Information of DataFrame
Null Values Occur
Remove Null Values
Fill in Value
Specify Column to Fill

Chapter 4
Fill the Average Value
Fill the Middle Value
Fill the Most Hot Value
Wrong Formats Occur
Correct Wrong Format
Incorrect Data Occur
Remove Incorrect Data
Modify Incorrect Data (1)
Modify Incorrect Data (2)
Duplicate Data
Find Duplicate Data
Remove Duplicate Data

Chapter 5
Data Correlation
Get Data Correlation
Data Correlation Chart:
Series Random Number
Check Series Empty
Check Series Size
Array Values of Series
Transpose a DataFrame
Check Data Type
Array Values of DataFrame
Size, Ndim, Shape

Chapter 6
The Sum of Each Column
The Prod of Each Column
The Maximum Values
The Minimum Values
Standard Deviation
The Number of Rows
The DataFrame Description
Case Convsion
String Length
Number of Characters
Find the Index
Other String Functions

Chapter 7
Row Name & Column Name
Sort by Row Names
Sort by Column Names
Sort in Ascending Order
Sort in Descending Order
Sort Vales by Column
Rename Rows & Columns
Iterate Over DataFrame (1)
Iterate Over DataFrame (2)

Chapter 8
Iterate Over DataFrame (3)
Get Range of Regular Dates
Get Range of Business Dates
Get Range of Weekends
Get Range of Month End
Merge DataFrames
The Key of Left DataFrame
The Key of Right DataFrame

Pandas Exercises
Questions
Answers

Click the Buy button now. Start coding today!