Download the dataset csv file online. The documentation for this dataset is here: [login to view URL]
Use Python to answer the questions. You can also refer to the documentation in the link above.
1. Understanding the data:
a. What does one row/record of the data represent?
b. How many columns are there and (in your own words) briefly describe the information it stores?
2. For this dataset, how many columns are:
a. Integer type?
b. String type?
c. Float type?
3. What is the cardinality for the columns:
4. Which columns should be formatted as Boolean type but are not? Explain why they are not.
5. How many missing values are there per field?
6. How many total values are there for each unique value of the following columns:
7. Use the groupby function to answer the following questions:
a. There are two columns that capture if the mother or father was a college graduate. Find the number of students that had every possible combination. (i.e. both parents were college graduates, only the mother, only the father, or neither were college graduates)
b. For each possible “home” response, what is the average distance?
c. For each possible “region” and “home”, what is the average tuition?
d. For each possible “income” level, what is the average wage?
a. How many students lived more than 10 miles from the 4-year college?
b. How many students lived less than 10 miles from the 4-year college and family had “low” income?
c. How many students had both parents graduate from college and had high income levels?
Được trao cho:
14 freelancer chào giá trung bình₹2529 cho công việc này
Hello Dear, I have read project description and I can deliver your project within your given time frame because I have tremendous experience in such projects so you can contact me for further discussion.
Hi! I am a data scientist and I have done quite a lot of data exploration work in my projects, I am confident that I'll be able to do your task efficiently, kindly respond so we can further discuss. Thanks
Hello, I can help you analyze the data which you have in your homework using python.I can do this fast as possible but I have few doubt's here and there so please message me. Thanks
Hey there! I am an expert in python and I can do this work in a day. I can assure you 100% original and plagiarism work. Kindly contact me in chat. Regards