Class 12th Practical paper-2
QUESTION
Python Program
Q 1 Write a program in python to create the following dataframe named “country” storing the following details:
Considering the above dataframe answer the following queries by writing appropriate command in python pandas.
i. Add a new column named discount which is 10% of their bill amount.
ii. Add a row with row index 1008 as Rohan,Bharuch,6000,2011-04-01.
iii. Now plot a bar chart depicting the customer name on x-axis and their corresponding
bill amount on y-axis, with appropriate Graph title, x-axis title, y-axis title, gridlines
and color etc
Q – 2 Create below table “staff” and insert all records.
