Data Science Real Exercises using Python
This repo consists of solution to the homework assignments given in Udemy Course "Python A-Z: Python For Data Science with Real Exercises" by www.superdatascience.com.
Q. Write a Python Script to find the number of random numbers that fall between -1 and 1 and compare it with the expected value of 68.2%
#######Solution: Random Number Expected Value.ipynb
Q. You are a Data Scientist working for a consulting firm. One of your colleagues from the Auditing department has asked you to help them assess the financial statement of organisation X. You have been supplied with two vectors of data: monthly revenue and monthly expenses for the financial year in question. Your task is to calculate the following financial metrics:
- profit for each month
- profit after tax for each month (the tax rate is 30%)
- profit margin for each month - equals to profit after tax divided by revenue
- good months - where the profit after tax was greater than the mean for the year
- bad months - where the profit after tax was less than the mean for the year
- the best month - where the profit after tax was max for the year
- the worst month - where the profit after tax was min for the year
#######Solution: Financial Statement Analysis.ipynb
Q. Try to find out insights by plotting player's salary, in-game stats and see if you can find any discrepancy or other insight.
#######Solution: Basketball Data Visualization and Quick Insights.ipynb
Q. You have been supplied data for two more additional in-game statistics: • Free Throws • Free Throw Attempts You need to create three plots that portray the following insights: • Free Throw Attempts per game • Accuracy of Free Throws • Player playing style (2 vs 3 points preference) excluding Free Throws* *Each Free Throw is worth 1 point The data has been supplied in the form of vectors. You will have to create the two matrices before you proceed with the analysis
#######Solution: NBA_Data_Analysis.ipynb
Q. The world bank was very impressed with your deliverables on the previous assignment and they have a new project for you.
You are required to produce a scatterplot depicting Life Expectancy (y-axis) and Fertility Rate (x-axis) statistics by Country. The scatterplot need to be categorised by Countries Regions. You have been supplied with data for 2 years: 1960 and 2013 and you are requires to produce a visualisation for each of these years. Some data has been provided in a CSV file, some in Python lists. The CSV file contains combined data for both years. All data manipulations have to be performed in Python (not in Excel) because this project can be audited at the later stage. You also have been requested to provide insights into how the two periods compare.
#######Solution: World Life Expectancy and Fertility.ipynb
Q. Try to find out how critics rating and audience rating compare and standup wrt year and genre by creating a visually appealing dashboard of critics.
#######Solution: Movie Rating Dashboard.ipynb
Q. The movie reviews website was very happy with your deliverable for the previous assignment and now they have a new request for you.
The previous consultant had created a chart for them which is illustrated on the next slide. However the Python code used to create the diagram has since been lost and cannot be recovered. Your task is to come up with the code that will re-create the same chart making it look as close as possible to the original. A new dataset has been supplied.
#######Solution: Chart Replication for Movie Company.ipynb