#Imporing Pandas Library import pandas as pd import matplotlib.pyplot as plt df =…
- User
#Imporing Pandas Library import pandas as pd import matplotlib.pyplot as plt
df = pd.read_csv("data.csv", encoding = 'iso-8859-1')
Displays the first few rows of our dataset
print(df.head(10))
--
Data Cleaning
#Find No of Missing Values in Data #finds null values in df ,& adding it all for sum() missing_values = df.isnull().sum() print(missing_values)
#replace null values to 'no descrition' df['Description'].fillna('No Description', inplace = True)
#drop rows in cust id = Drop all na in cust id df = df.dropna(subset=['CustomerID'])
#DataValue is not standardied not in date format that hard for python to parse it. #so we change invoice date to Date Format df['InvoiceDate'] = pd.to_datetime(df['InvoiceDate'])
#Remove any rows where quantity or UnitPrice is <= 0 df = df[(df['Quantity'] > 0) & (df['UnitPrice'] > 0)]
#Actual DA = To discove patterns, Spot Anomalies, test hypothesis & Just check assumptions which gives us idea of WHAT DATA WE're ANALYSIZING #step 1 = summary_statistics(count,mean, min, %, std deviation & key statistics) summary_statistics = df.describe() print(summary_statistics)
#Count Unique Items that r sold unique_item_count = df['Description'].nunique() print(unique_item_count)
#what r the total sales df['Sales'] = df['Quantity']*df['UnitPrice']
#top item that r sold top_items = df.groupby('Description')['Sales'].sum().sort_values(ascending=False).head(10) print(top_items)
product_sales = df.groupby('Description').agg(Total_Quantity_Sold=('Quantity','sum')).reset_index() product_sales_sorted = product_sales.sort_values(by='Total_Quantity_Sold', ascending=False) top_10_products = product_sales_sorted.head(10) plt.figure(figsize=(12,8)) plt.barh(top_10_products['Description'],top_10_products['Total_Quantity_Sold']) plt.xlabel('Total Quantity Sold') plt.ylabel('Product Description') plt.title('Top 10 Popular Products') plt.gca().invert_yaxis() plt.show()
#convert InvoiceDate to datetime format df['InvoiceDate'] = pd.to_datetime(df['InvoiceDate'])
#Filter DF for WORLD WAR2 GLIDERS ASSTD DESIGNS sold over time gliders_data = df[df['Description'] == 'WORLD WAR2 GLIDERS ASSTD DESIGNS']
#Group data by month & sum up quantities to see total no sold over time gliders_sales_over_time = gliders_data.groupby(gliders_data['InvoiceDate'].dt.to_period('M'))['Quantity'].sum().reset_index()
#Convert the InvoiceDate from period to timestamp for plotting gliders_sales_over_time['InvoiceDate'] = gliders_sales_over_time['InvoiceDate'].dt.to_timestamp()
#plot time series for quantity of gliders sold plt.figure(figsize=(14, 7)) plt.plot(gliders_sales_over_time['InvoiceDate'], gliders_sales_over_time['Quantity'], marker='o') plt.title('Quantity of WORLD WAR2 GLIDERS ASSTD DESIGNS sold over time') plt.xlabel('Date') plt.ylabel('Quantity Sold') plt.grid(True) plt.show()
in this code, i am working in eCommerce data analysis where i written code for line chart but it is not showing line only showing blank chart
- Assistant
There may be several reasons why your plot isn't showing the expected data. Let's troubleshoot the problem step by step.
-
Check if
gliders_dataDataFrame is empty: If there are no rows matching the description "WORLD WAR2 GLIDERS ASSTD DESIGNS", then thegliders_sales_over_timewill also be empty, resulting in a blank plot. -
Check data types and conversions: Ensure that
InvoiceDateis correctly converted todatetimeand aggregated by month. -
Check if plotting data exists: Verify if the grouped data (
gliders_sales_over_time) contains the expected data before plotting.
We can start by printing the
gliders_dataandgliders_sales_over_timeDataFrame to check the data. Here's the modified code adding these checks:import pandas as pd import matplotlib.pyplot as plt df = pd.read_csv("data.csv", encoding='iso-8859-1') # Data Cleaning df['Description'].fillna('No Description', inplace=True) df = df.dropna(subset=['CustomerID']) df['InvoiceDate'] = pd.to_datetime(df['InvoiceDate']) df = df[(df['Quantity'] > 0) & (df['UnitPrice'] > 0)] # Convert InvoiceDate to datetime format again just to be sure df['InvoiceDate'] = pd.to_datetime(df['InvoiceDate']) # Filter DF for WORLD WAR2 GLIDERS ASSTD DESIGNS sold over time gliders_data = df[df['Description'] == 'WORLD WAR2 GLIDERS ASSTD DESIGNS'] # Debugging: Print to check if `gliders_data` is not empty print("Gliders Data:") print(gliders_data) # Group data by month and sum up quantities to see total no sold over time gliders_sales_over_time = gliders_data.groupby(gliders_data['InvoiceDate'].dt.to_period('M'))['Quantity'].sum().reset_index() # Debugging: Print to check if `gliders_sales_over_time` is not empty print("Gliders Sales Over Time:") print(gliders_sales_over_time) # Convert the InvoiceDate from period to timestamp for plotting gliders_sales_over_time['InvoiceDate'] = gliders_sales_over_time['InvoiceDate'].dt.to_timestamp() # Plot time series for quantity of gliders sold plt.figure(figsize=(14, 7)) plt.plot(gliders_sales_over_time['InvoiceDate'], gliders_sales_over_time['Quantity'], marker='o') plt.title('Quantity of WORLD WAR2 GLIDERS ASSTD DESIGNS sold over time') plt.xlabel('Date') plt.ylabel('Quantity Sold') plt.grid(True) plt.show()These print statements will help you understand if you have the right data in
gliders_dataandgliders_sales_over_time. If the prints show empty DataFrames, it means there's something wrong with how the data is filtered or grouped.If the data looks correct but the plot is still blank, ensure you have correctly set up your plotting environment and no errors occurred while plotting. Also, make sure Matplotlib is updated to the latest version if necessary.
Finally, if everything appears to be correct but the plot still doesn't display as expected, check for any potential warnings or errors during the plotting process.
-