Replicating the IFS Family with Pandas
Now, how does Pandas Implement these functions compared to Excel? 🐼
Video Game Sales Analysis
Step One - Import your Data
input_1
print(input_1)
hovno
import pandas as pd
import numpy as np
dataframe = pd.read_csv("/work/Video_Game_Sales.csv")
dataframe
Step Two - Formulate your Aggregation Function
dataframe.query("Global_Sales_M>=10").groupby(['Platform','Publisher']).count()['Year'].reset_index().sort_values(by='Year', ascending=False)
#Specify the Libraries Needed
import plotly.express as px
platform_df = dataframe.groupby(['Platform','Year']).sum()['Global_Sales_M'].reset_index().groupby('Platform').sum().sort_values(by=['Global_Sales_M'], ascending=False)['Global_Sales_M'].reset_index()
px.bar(platform_df, x='Platform', y='Global_Sales_M', title="Platform Sales - Macro View")