text_plain_output_1.png
import pandas as pd

df1 = pd.read_csv('/kaggle/input/walmart-sales-analysis/Walmart.csv', index_col='Order ID')

df1.shape

df1.columns

df1.nunique()

df1.isna().sum()

df1['Profit/Unit'] = df1['Profit'] / df1['Quantity']
df1['Price'] = df1['Sales'] / df1['Quantity']
df1['Cost Per Unit'] = df1['Price'] - df1['Profit/Unit']
df1.sample(3)