Practice Questions

Ecommerce Purchases Data Analysis Exercises (Pandas Practice)

Comments

Post a Comment

Popular posts from this blog

NumPy: A Comprehensive Guide with Examples | Lecture 1

  NumPy: A Comprehensive Guide with Examples NumPy (Numerical Python) is a powerful library in Python for numerical computing. It provides support for large, multi-dimensional arrays and matrices, along with a collection of mathematical functions to operate on these arrays. Key Features of NumPy Efficient multi-dimensional array support : ndarray is the core object. Broadcasting : Operate on arrays of different shapes. Vectorized operations : Faster computation compared to loops. Integration with other libraries : Pandas, SciPy, etc. Extensive math functions : Trigonometric, statistical, and linear algebra. Getting Started with NumPy Installation pip install numpy Importing NumPy import numpy as np Core Concepts 1. Creating Arrays # 1D array arr1 = np.array([1, 2, 3, 4]) print(arr1)   # 2D array arr2 = np.array([[1, 2], [3, 4]]) print(arr2)   # Array with zeros zeros = np.zeros((3, 3...
Read more

Ecommerce Purchases Data Analysis Exercises (Pandas Practice)

  Ecommerce Purchases Data Analysis Exercises (Pandas Practice) Are you learning Python Pandas for Data Analysis ?  This hands-on exercise will help you practice real-world data analysis using an Ecommerce Purchases dataset . Follow the questions step-by-step and try solving them using Pandas . Dataset Setup First, import Pandas and load the dataset: import pandas as pd ecom = pd.read_csv('Ecommerce Purchases') You can download the dataset from any dataset websites like kaggle and UCI or comment us and we will share you the data Basic Data Exploration 1. Check the first few rows of the dataset  Use .head() to view the dataset. 2. How many rows and columns are there? Use .info() to get dataset structure. Purchase Price Analysis 3. What is the average Purchase Price? 4. What are the highest and lowest purchase prices? User Insights 5. How many people have English ( 'en' ) as their language? 6. How many people have the job title "Lawyer" ? Time-Based Analysis 7...
Read more

Handling Missing Data in Python DataFrames | Lecture 4

  Handling Missing Data in Python DataFrames Missing data is a common issue in data analysis, and Pandas provides several ways to handle it. Here's an overview with examples: 1. Identifying Missing Data Missing data in a DataFrame is often represented as NaN (Not a Number). You can use these methods to detect them: isnull() : Returns True for missing values. notnull() : Returns False for missing values. Example: import pandas as pd import numpy as np   # Creating a DataFrame with missing values data = {     "Name": ["Alice", "Bob", "Charlie", None],     "Age": [25, np.nan, 30, 22],     "Score": [85, 90, np.nan, 88] } df = pd.DataFrame(data)   # Detect missing values print(df.isnull())   # Check for non-missing values print(df.notnull()) 2. Dropping Missing Data dropna() : Removes rows or columns with missing values. Example: # Drop rows with any ...
Read more