Pandas Tutorial

• Introduction to Pandas in Python
• How to Install Python Pandas on Windows and Linux?
• How To Use Jupyter Notebook - An Ultimate Guide

Creating Objects

• Python | Pandas DataFrame
• Creating a Pandas DataFrame
• Python | Pandas Series
• Creating a Pandas Series

Viewing Data

• View the top rows of the frame
• View the bottom rows of the frame
• View basic statistical details
• Convert the pandas DataFrame to numpy Array
• Convert the pandas Series to numpy Array
• Convert series or dataframe object to Numpy-array using .as_matrix().

Selection

• Dealing with Rows and Columns in Pandas DataFrame
• How to select multiple columns in a pandas dataframe
• Python | Pandas Extracting rows using .loc[]
• Python | Extracting rows using Pandas .iloc[]
• Indexing and Selecting Data with Pandas
• Boolean Indexing in Pandas
• Label and Integer based slicing technique using DataFrame.ix[ ]

Manipulating Data

• Adding new column to existing DataFrame in Pandas
• Python | Delete rows/columns from DataFrame
• Truncate a DataFrame before and after some index value
• Truncate a Series before and after some index value
• Iterating over rows and columns in Pandas DataFrame
• Working with Missing Data in Pandas
• Sorts a data frame in Pandas

Grouping Data

• Pandas GroupBy
• Grouping Rows in pandas
• Combining multiple columns in Pandas groupby with dictionary

Merging, Joining and Concatenating

• Python | Pandas Merging, Joining, and Concatenating
• Concatenate Strings
• Append rows to Dataframe
• Concatenate two or more series
• Append a single or a collection of indices
• Combine two series into one
• Add a row at top in pandas DataFrame
• Join all elements in list present in a series
• Join two text columns into a single column in Pandas

Working with Date and Time

• Python | Working with date and time using Pandas
• Timestamp using Pandas
• Current Time using Pandas
• Convert timestamp to ISO Format
• Get datetime object using Pandas
• Replace the member values of the given Timestamp
• Convert string Date time into Python Date time object using Pandas
• Get a fixed frequency DatetimeIndex using Pandas

Working With Text Data

• Python | Pandas Working With Text Data
• Convert String into lower, upper or camel case
• Replace Text Value
• Replace Text Value using series.replace()
• Removing Whitespaces
• Move dates forward a given number of valid dates using Pandas

Working with CSV and Excel files

• Read csv using pandas
• Saving a Pandas Dataframe as a CSV
• Loading Excel spreadsheet as pandas DataFrame
• Creating a dataframe using Excel files
• Working with Pandas and XlsxWriter

Operations

• Apply a function on the possible series
• Apply function to every row in a Pandas DataFrame
• Apply a function on each element of the series
• Aggregation data across one or more column
• Mean of the values for the requested axis
• Mean of the underlying data in the Series
• Mean absolute deviation of the values for the requested axis
• Mean absolute deviation of the values for the Series
• Unbiased standard error of the mean
• Find the Series containing counts of unique values
• Find the Series containing counts of unique values using Index.value_counts()

Visualization

• Pandas Built-in Data Visualization
• Data analysis and Visualization with Python
• Box plot visualization with Pandas and Seaborn

Applications and Projects

• How to Do a vLookup in Python using pandas
• Convert CSV to HTML Table in Python
• KDE Plot Visualization with Pandas and Seaborn
• Analyzing selling price of used cars using Python
• Add CSS to the Jupyter Notebook using Pandas

How to Install Python Pandas on Windows and Linux?

Installing Python's Pandas library is straightforward thanks to the package manager pip. Here's a tutorial on how to install Pandas on both Windows and Linux:

Prerequisite:

Make sure you have Python and pip installed. You can check their presence by using:

For Python:

python --version

For pip:

pip --version

If you don't have Python installed, download it from the official website. During the installation of Python (especially on Windows), ensure that you check the box that says "Add Python to PATH" to make sure pip works from the command line.

Installation:

On Windows:

• Using pip:

Open Command Prompt (cmd) and type:

pip install pandas

If you encounter any permission issues, try running the Command Prompt as an Administrator.

• Using Anaconda (optional):

If you're using the Anaconda distribution of Python, you can install Pandas via the conda package manager:

conda install pandas

On Linux:

• Using pip:

Open your terminal and type:

pip install pandas

or

pip3 install pandas

If you're not the superuser and encounter permission issues, use:

sudo pip install pandas

or

sudo pip3 install pandas

• Using Anaconda (optional):

If you're using the Anaconda distribution of Python on Linux, you can install Pandas via:

conda install pandas

Post-Installation:

After installation, you can verify if Pandas is installed correctly:

python -c "import pandas; print(pandas.__version__)"

This command will print the version of Pandas if it's installed correctly.

This tutorial should help you set up Pandas on both Windows and Linux. Once installed, you can start enjoying the powerful data analysis and manipulation capabilities that Pandas offers!

1. Installing Pandas using pip on Linux:

   # Installing Pandas on Linux using pip
   pip install pandas
   

2. Installing Pandas using pip on Windows:

   # Installing Pandas on Windows using pip
   pip install pandas
   

3. How to install Pandas library on Linux distribution:

   # Installing Pandas on Linux using package manager (e.g., apt)
   sudo apt-get update
   sudo apt-get install python3-pandas
   

4. Checking Python and Pandas versions after installation:

   # Checking Python and Pandas versions
   python --version
   python -m pip show pandas
   

5. Pandas installation in virtual environments on Windows and Linux:

   # Creating and activating a virtual environment
   python -m venv venv
   source venv/bin/activate  # Linux
   .\venv\Scripts\activate   # Windows
   
   # Installing Pandas in the virtual environment
   pip install pandas
   

6. Installing Pandas with specific Python versions on Windows:

   # Installing Pandas with specific Python version on Windows
   python -m pip install pandas==x.x.x
   

7. Using conda for Pandas installation on Windows and Linux:

   # Installing Pandas with conda
   conda install pandas
   

8. Code examples and demonstrations for Pandas installation on both Windows and Linux: