- Consider the Dataframe(DF) and write the python program to find the following:
|
Name Of Employee |
Sales |
Quarter |
State |
0 |
Mohak |
1000 |
1 |
Rajasthan |
1 |
Vijay |
300 |
1 |
Panjab |
2 |
Tapasi |
400 |
1 |
Gujarat |
3 |
Mansi |
500 |
1 |
Goa |
4 |
Bipin |
800 |
2 |
Rajasthan |
5 |
Mohak |
1000 |
2 |
Gujarat |
6 |
Vijay |
500 |
2 |
Panjab |
7 |
Tapasi |
700 |
2 |
Gujarat |
8 |
Mansi |
50 |
2 |
Rajasthan |
9 |
Bipin |
60 |
2 |
Rajasthan |
10 |
Mohak |
1000 |
3 |
Rajasthan |
- Find total sales per employee in above dataframe. (Ex:- Mohak sales is 3000)
- Find total sales by state in above dataframe(Ex:-Rajasthan sales is 2910 )
- Consider the above Dataframe(DF) and write the python program to find the following:
- Find Max individual sale by State in above dataframe
- Find Mean, median and min sales by Each State in above dataframe
where is its solution
ReplyDelete