#Q1
    supermarket = data.frame(
  bill_id = c(501,502,503,504,505,506),
  customer_name = c("Aman", "Riya", "Karan", "Neha", "Rohit", "Simran"),
  gender = factor(c("Male", "Female", "Male", "Female", "Male", "Female")),
  membership = factor(c("Gold", "Silver)", "Gold", "None", "Silver", "Gold")),
  category = factor(c("Grocery", "Electronics", "Clothing", "Grocery", "Electronics", "Clothing")),
  quantity = c(10,1,3,8,2,5),
  cost_price = c(50,20000,800,60,18000,700),
  selling_price = c(70,25000,1000,80,22000,900),
  discount = c(100,2000,150,50,500,300),
  delevery_type = factor(c("Home", "Store", "Home", "Store", "Home", "Home"))
)
print(supermarket)
##   bill_id customer_name gender membership    category quantity cost_price
## 1     501          Aman   Male       Gold     Grocery       10         50
## 2     502          Riya Female    Silver) Electronics        1      20000
## 3     503         Karan   Male       Gold    Clothing        3        800
## 4     504          Neha Female       None     Grocery        8         60
## 5     505         Rohit   Male     Silver Electronics        2      18000
## 6     506        Simran Female       Gold    Clothing        5        700
##   selling_price discount delevery_type
## 1            70      100          Home
## 2         25000     2000         Store
## 3          1000      150          Home
## 4            80       50         Store
## 5         22000      500          Home
## 6           900      300          Home
#Add Gross Revenue
supermarket$gross_revenue <- supermarket$quantity * supermarket$selling_price
print(supermarket$gross_revenue)
## [1]   700 25000  3000   640 44000  4500