# Pandas-Zaka801

**Repository Path**: wang-tx_1_0/pandas-zaka801

## Basic Information

- **Project Name**: Pandas-Zaka801
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-12-10
- **Last Updated**: 2025-12-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

Section 1:

Q:1: Creates a Pandas Series with custom indices and prints it.
Q:2: Creates a Pandas Series from a dictionary and prints it.
Q:3: Creates a Pandas DataFrame from a dictionary and prints it.
Q:4: Extends Q:3 by setting custom indices for the DataFrame and prints it.
Q:5: Extends Q:3 by calculating mean, maximum, and minimum values for the 'temperature' column and prints them.
Section 2:

Q:6: Reads a CSV file ('people.csv'), selects specific columns, sets 'Sex' and 'Job Title' as index columns, skips certain rows, and exports the modified DataFrame to a new CSV file ('NewPeople.csv').
Q:7: Reads an Excel file ('SampleWork.xlsx'), imports specific columns from sheet 1, sets row 2 as the header, skips certain rows, and exports the modified DataFrame to a new sheet in the same Excel file ('SampleWork.xlsx').
Section 3:

Q:8: Creates a DataFrame named AICP_DF from a dictionary, selects specific columns 'Name' and 'Qualification' and saves them to df1, adds a new column 'Height' to AICP_DF, sets 'Name' column as the index column, retrieves rows with specific indices ('Hifza' and 3), and drops a row with index 'Bilal'.
Each task is accompanied by code blocks that perform the described operations and output the results accordingly. Additionally, comments are provided within the code blocks to explain each step or operation.