ZuoTi.Pro
Question

Python

Take student data with Enrollment number, name,
gender, semester wise, subject wise marks, address with geographical location
and other necessary data and perform following analytics and visualization

 

a.       Find the average marks of the student in one semester and across all semesters.

b.      Find gender wise average marks in all semesters

c.       Classify the students with average, good and excellent on the basis of marks

d.      Visualize the result gender wise, geographical location wise, subject wise and identify
the subjects in which students are weak.


Here the Data Set

Enrollment No. Student's Name Gender(M/F) Sem1 Sem2 Sem3 Sem4 Sem5 Sem6 Sem7 Sem8 Current Address latitude longitude
06CP001 Hardik Male 8 7 7 6 6 9 8 5 Avirath Tower 202, Gyananand Greens, Sayanji Pura, Ajwa Road, Vadodara-390019. 22.3276629 73.2492436
06CP002 Payal Female 8 8 6 8 6 4 7 7 PATEL FALIYA,SUBHANPURA,VADODARA,GUJARAT. 22.3214339 73.1608316
06CP003 Urvashi Female 7 9 4 4 5 0 7 4 53,near swaminarayan tample ruvad, at&post:-ruvad, ta&dist:-vadodara,pincode:-391220 22.139762 73.2378329
06CP004 Heema Female 0 4 7 6 4 0 8 4 605,sharad nagar, tarsali, vadodara 22.2586626 73.2147607
06CP005 Charmi Female 5 0 8 4 6 7 6 4 41, Gayatri Nagar Society, Near Govindrao Park, Outside Panigate, Ajwa Road, Vadodara 22.3017307 73.2218652
06CP006 Raj Male 4 0 8 4 8 5 7 6 F-404, VICENZA 51 APP, B\H ATLADARA WATER TANK, ATLADARA, VADODARA 22.2680318 73.1517404
06CP007 Gitu Female 7 6 6 7 0 7 6 0 C/55 ANAND SAGAR SOCIETY TARSALI, BARODA 22.253297 73.2136861
06CP008 Raksha Female 5 4 8 4 6 9 0 5 3 Sonal Vatika Society, Sayaji Park, Ajwa Road, Vadodara 390 019 22.3153779 73.2399526
06CP009 Harsh Male 6 6 7 9 4 6 5 5 C-302, Status Enclave, behind Flavoure Restaurent, Makarpura 22.262217 73.20044
06CP010 Deepthi Female 7 0 7 9 7 7 9 0 A-6 Amrapali Duplex, B/H Swati Society,New Sama Road, Vadodara 22.3423716 73.1875031
06CP011 Vishwa Female 4 6 6 4 4 5 0 6 B-18 KARELIBAUG SOCIETY, B/H BRIGHT SCHOOL, V.I.P. ROAD, VADODARA 390 018 22.3272362 73.2035255
06CP012 Pooja Female 4 4 7 5 7 6 8 4 B/38 prabhukrupa soci,chankyapuri char rasta,new sama road,vadodara 22.3420008 73.1887204
06CP013 Hinka Female 4 5 4 8 4 9 9 6 B-92,UMIYANAGAR DUPLEX,NEAR CHANKYAPURI CHAR RASTA,NEW SAMA ROAD,VADODARA-390024 22.3460628 73.1943179
06CP014 Harshita Female 8 6 5 4 9 8 4 8 D-1001 Sangani Aditya Heights, Opp. Sangath Platina, Motera, Ahmedabad 23.1018263 72.5992082
06CP015 Palak Male 8 7 4 7 6 7 4 6 Vedmandir,Bahucharaji road,Karelibaug,Vadodara 390018 22.311523 73.1985633
06CP016 Neelam Female 9 6 9 7 7 6 6 4 C-21.SHREEJIDHAM SOCIETY,OPP. AASTHA HOSPITAL,VASNA ROAD,VADODARA-390007 22.2966781 73.1518308
06CP017 Kruti Female 9 6 9 8 6 6 0 7 C-/730, Sector-1, Reliance Township, Refinery Road, Vadodara. 22.3510324 73.1424474
06CP018 Charmi Female 4 9 7 7 6 6 5 4 306,Swaminarayan nagar complex-1,near ramvatika,Waghodia road,Vadodara 22.294046 73.22388
06CP019 Sahil Male 4 4 7 4 4 7 4 7 C-302,STATUS ENCLAVE,BEHIND FLAVORS RESTAURANT,MAKARPURA ROAD,VADODARA-390009 22.262217 73.20044
06CP020 Trisha Female 4 6 7 6 10 4 4 6 25-a,vallabh vatika, near vadsar Bridge, vadodara, 390010 22.2590907 73.1760394
06CP021 Heena Female 5 4 4 10 6 7 4 6 F-13 kortiyark nagar,near shasti baug,wadi,vadodara 22.2954372 73.2203562
06CP022 Umang Male 4 5 7 7 4 8 4 4 C302, Status Enclave, Behind Flavors Restaurant, Makarpura Road, Vadodara - 390009 22.262217 73.20044
06CP023 Krishna Female 0 6 6 6 9 8 0 7 175- ramdev nagar society, bapod jakatnaka, waghodia road, Vadodara. 22.297801 73.2350682
06CP024 Yatin Male 4 6 4 9 6 5 6 6 301 , Lillier Complex , Akota , Vadodara 22.2925278 73.1723812
06CP025 Veena Female 4 6 7 6 0 4 4 4 E 23 DESAI NAGAR TARSALI VADODARA OPP.TARSALI TALAV VADODARA 22.252713 73.217226
06CP026 Shreya Female 6 6 0 4 8 5 0 8 D-101,Smnath apt.,nr. Somnath nagar,Ravipark,Tarsali,Vadodara 22.2524402 73.2114255
06CP027 Anamika Female 8 7 4 7 5 7 5 4 B/38 Amrutnagar soc,opp Panasonic, Ne. New era school,Makarpura road, Vadodara 22.2525231 73.1996551



Pandas   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 9 more requests to produce the answer.

1 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Python
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • A new online social media platform (designed to be particularly addictive) was been launched in the...

    A new online social media platform (designed to be particularly addictive) was been launched in the Northeast US. The developers are interested in knowing if women spend more time on the service than men. Of course, this knowledge would help in the creation of a killer marketing plan. Do a hypothesis test Gender Hours online/week Friends female 4 150 female 10 400 female 9 260 female 5 70 female 7 90 female 12 110 female 2 30 female 6 80...

  • SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male...

    SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male 4500 Canada 3 Pam Female 5500 USA 4 Sara Female 4000 Canada 5 Todd Male 3500 Canada 6 Mary Female 5000 UK 7 Ben Male 6500 UK 8 Elizabeth Female 7000 USA 9 Tom Male 5500 UK 10 Ron Male 5000 USA Given the EMPLOYEE table above, write a query that would produce the output below. COUNTRY    GENDER     Total Salary ---------- ---------- ------------ Canada     Female             4000 Canada     Male               8000 UK         Female             5000...

  • IN PYTHON ONLY I am looking for 4 columns, Age, Gender, Ideal Age of a Spouse,...

    IN PYTHON ONLY I am looking for 4 columns, Age, Gender, Ideal Age of a Spouse, and the message. I will have 6 rows in the table, and 4 columns, followed by  averages. Calculate the ideal age of a spouse. Enter either m or f from the keyboard in lower case. You may use string data for the gender. Convert the gender to upper case Enter an age from the keyboard, probably an integer You will need prompts telling the user...

  • IN PYTHON ONLY I am looking for 4 columns, Age, Gender, Ideal Age of a Spouse, and the message. I will have 6 rows in th...

    IN PYTHON ONLY I am looking for 4 columns, Age, Gender, Ideal Age of a Spouse, and the message. I will have 6 rows in the table, and 4 columns, followed by  averages. Calculate the ideal age of a spouse. Enter either m or f from the keyboard in lower case. You may use string data for the gender. Convert the gender to upper case Enter an age from the keyboard, probably an integer You will need prompts telling the...

  • SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male...

    SQL/Oracle EMPLOYEE Table ID NAME GENDER SALARY COUNTRY 1 Mark Male 5000 USA 2 John Male 4500 Canada 3 Pam Female 5500 USA 4 Sara Female 4000 Canada 5 Todd Male 3500 Canada 6 Mary Female 5000 UK 7 Ben Male 6500 UK 8 Elizabeth Female 7000 USA 9 Tom Male 5500 UK 10 Ron Male 5000 USA Given the EMPLOYEE table above, write a query that would produce the output below. COUNTRY    GENDER     Total Salary ---------- ---------- ------------ Canada     Female             4000 Canada     Male               8000 Canada     NULL              12000...

  • please help me with this assignment. thank you. In this assignment you will conduct a one-way...

    please help me with this assignment. thank you. In this assignment you will conduct a one-way and factorial ANVOA and interpret the results. You will be presented with 2 studies: In the first you will (1) state populations and hypotheses; (2) conduct a One-way ANOVA using SPSS; (3) report the results using proper APA format; (4) if there was a significant result, conduct post-hoc tests; (5) describe the results to this study; (6) describe the implications of this study; (7)...

  • PYTHON*************** Create a Person Class that: Accepts First Name, Last Name, Age, and Gender Has a...

    PYTHON*************** Create a Person Class that: Accepts First Name, Last Name, Age, and Gender Has a method that adds all persons Validate all input, not left empty for First Name, Last Name, Gender and numeric for age and throw an exception if it does not validate within the class. Create a Student Class that: Inherits the Person Class Accepts GPA Validate GPA (>= 0 and <= 4.0) and throw exception if it does not validate within the class. Has methods...

  • Evolution theory predicts a physiological cost of increased reproduction that translates in short...

    Evolution theory predicts a physiological cost of increased reproduction that translates in shorter life span. The data file Large.Fruitftly describes a study of the cost of sexual activity in male Drosophila. The authors randomly assigned male fruit flies to five sex conditions. In the first condition, the males were kept alone. In the second condition, each male was placed in the company of one virgin female (replaced every other day with a new virgin female to provide reproductive opportunities). The...

  • How many three-letter "words" can be made from 6 letters "FGHIJK" if repetition of letters (a)...

    How many three-letter "words" can be made from 6 letters "FGHIJK" if repetition of letters (a) is allowed? An access code consists of 1 letter of the alphabet followed by 6 digits. (Digits are 0, 1, 2, 3, 4, 5, 6, 7, 8, 9.) How many different access codes are possible? A jar contains 9 red marbles, numbered 1 to 9, and 12 blue marbles numbered 1 to 12. a) A marble is chosen at random. If you're told the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT