Homework Help Question & Answers

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



0 0
Add a comment
Answer

This Homework Help Question: "Python" No answers yet.

Be the First!

Request Answer

Request answer!

We need 9 more requests to produce the answer to this homework help question. Share with your friends to get the answer faster!

1 /10 have requested the answer to this homework help question.

Request! (Login Required) Share with friends


Once 10 people have made a request, the answer to this question will be available in 1-2 days.
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 Coin

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 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, 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 programming- Download the following two files you will need for this activity: customerData.csv This file...

    Python programming- Download the following two files you will need for this activity: customerData.csv This file contains randomly generated fictitious customer data. customer_regex.py This is a Python script that imports the customer data into a list of customer details. In your personal playground in Codio, upload the two files and investigate the contents before considering the task you will pose to your peers. Assume the position of a manager of an online retailer. Pose a question to your IT expert...

  • 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...

  • 5. The Success Academy is organizing an event for its students. Write a Python program that...

    5. The Success Academy is organizing an event for its students. Write a Python program that prompts the user to enter the student's age and gender. The program should then display the day and time for the event registration based on the table below: Gender Registration Monday, 10:00am- 12:00pm Tuesday, 9:00am-12:00pm Wednesday, 9:00am-12:00pm Age Below 10 years old 10 years old and above Male Female Write a Python program that prompts the user to enter his/her monthly weight for the...

  • Organize and Display Data Data in the following data table were collected from a class of 9th grade students. ID...

    Organize and Display Data Data in the following data table were collected from a class of 9th grade students. ID Gender Height (m) Female 2 Weight (kg) Exercise per week 6 Days 4 Days 0 Days 1 Day 1 Day 0 Days 1 Day 4 Days 4 Days 7 Days 1 Day 2 Days 0 Days 2 Days 7 Days 0 Days 4 Days 6 Days 3 Days 2 Days 6 Days 5 Days 0 Days 0 Days 7 Days...

  • Do women feel differently from men when it comes to tax rates? One question on a...

    Do women feel differently from men when it comes to tax rates? One question on a survey of randomly selected adults asked, "What percent of income do you believe individuals should pay in income tax?" Complete parts a) through c). Click the icon to view the survey results. a) Draw side-by-side boxplots of tax rates by gender. Choose the correct graph below. Survey Results OA. ОВ. A 10 20 30 40 10 20 30 40 M Oc OD 40 40...

Free Homework 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.