Pandas in Python

 Pandas is a widely used open-source Python library for data manipulation and analysis. It provides easy-to-use data structures and functions designed to work with structured data. Here's a brief overview of some of its key features:

1. DataFrame: The core data structure in Pandas is the DataFrame, which is a two-dimensional labeled data structure with columns that can be of different types (e.g., numerical, categorical, datetime). It is similar to a spreadsheet or SQL table.

2. Series: A Series is a one-dimensional labeled array capable of holding any data type. It can be thought of as a single column of a DataFrame.

3. Data manipulation: Pandas provides a wide range of functionalities for manipulating data, including selecting, filtering, sorting, grouping, merging, and reshaping data.

4. Data cleaning: Pandas offers tools for handling missing data, removing duplicates, and transforming data formats.

5. Reading and writing data: Pandas supports reading data from various file formats such as CSV, Excel, JSON, SQL databases, and more. It also provides functions to write data back to these formats.

6. Time series analysis: Pandas has robust support for time series data, including date/time indexing, resampling, and time zone handling.

7. Statistical analysis: Pandas includes statistical functions for descriptive statistics, correlation, covariance, and more.

8. Visualization: While Pandas itself does not offer visualization capabilities, it integrates well with other libraries like Matplotlib and Seaborn for creating plots and visualizations directly from DataFrame objects.

Here's a simple example demonstrating the basic usage of Pandas:

import pandas as pd # Create a DataFrame data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'], 'Age': [25, 30, 35, 40], 'City': ['New York', 'Los Angeles', 'Chicago', 'Houston']} df = pd.DataFrame(data) # Display the DataFrame print(df) # Selecting a column print(df['Name']) # Filtering rows print(df[df['Age'] > 30]) # Adding a new column df['Gender'] = ['Female', 'Male', 'Male', 'Male'] print(df)

# Reading data from a CSV file csv_df = pd.read_csv('data.csv') # Writing data to a CSV file df.to_csv('output.csv', index=False)

Example of Numpy

 import numpy as np

# Creating a one-dimensional array

array1 = np.array([1, 2, 3, 4, 5])

print("One-dimensional array:")

print(array1)

# Accessing elements in the array

print("\nAccessing elements:")

print("First element:", array1[0])  # Accessing the first element

print("Last element:", array1[-1])  # Accessing the last element

# Performing operations on arrays

print("\nPerforming operations:")

array2 = np.array([6, 7, 8, 9, 10])

print("Array 1 + Array 2:", array1 + array2)  # Adding two arrays together

print("Array 1 * 2:", array1 * 2)  # Multiplying array1 by 2

# Creating a two-dimensional array (matrix)

matrix = np.array([[1, 2, 3],

                   [4, 5, 6],

                   [7, 8, 9]])

print("\nTwo-dimensional array (matrix):")

print(matrix)

# Accessing elements in the matrix

print("\nAccessing elements in the matrix:")

print("Element at row 1, column 1:", matrix[0, 0])  # Accessing the element at row 1, column 1

print("Second row:", matrix[1, :])  # Accessing the second row

print("Third column:", matrix[:, 2])  # Accessing the third column

# Transposing the matrix

print("\nTransposed matrix:")

print(np.transpose(matrix))

# Finding the sum of elements in the matrix

print("\nSum of elements in the matrix:", np.sum(matrix))

# Generating a random array

random_array = np.random.randint(1, 100, size=(3, 3))  # Generating a 3x3 array with random integers from 1 to 100

print("\nRandom array:")

print(random_array)

Numpy Library Functions

 

Function	Description
np.array()	Create an array.
np.zeros()	Create an array filled with zeros.
np.ones()	Create an array filled with ones.
np.arange()	Return evenly spaced values within a given interval.
np.linspace()	Return evenly spaced numbers over a specified interval.
np.random.rand()	Generate random numbers from a uniform distribution.
np.random.randn()	Generate random numbers from a normal (Gaussian) distribution.
np.min()	Return the minimum value along a given axis.
np.max()	Return the maximum value along a given axis.
np.sum()	Return the sum of array elements over a given axis.
np.mean()	Compute the arithmetic mean along a specified axis.
np.median()	Compute the median along a specified axis.
np.std()	Compute the standard deviation along a specified axis.
np.dot()	Compute the dot product of two arrays.
np.transpose()	Reverse or permute the axes of an array.
np.reshape()	Give a new shape to an array without changing its data.
np.concatenate()	Join a sequence of arrays along an existing axis.
np.split()	Split an array into multiple sub-arrays.
np.unique()	Find the unique elements of an array.
np.argsort()	Return the indices that would sort an array.
np.argmax()	Return the indices of the maximum values along an axis.
np.argmin()	Return the indices of the minimum values along an axis.
np.where()	Return elements chosen from x or y depending on condition.
np.clip()	Clip (limit) the values in an array.
np.isnan()	Test element-wise for NaN (Not a Number).
np.isinf()	Test element-wise for positive or negative infinity.
np.all()	Test whether all array elements along a given axis evaluate to True.
np.any()	Test whether any array element along a given axis evaluates to True.
np.save()	Save an array to a binary file in NumPy .npy format.
np.load()	Load an array from a binary file saved with np.save().

These are just a few of the many functions available in the NumPy library, which is widely used for numerical computing in Python.