Analytics Programming DAV 5400

My Data Analytics and Visualization Master Degree course with projects to create rich data analytics and visualization workflows with Python. Click here to see project file in Jupyter Notebook format

Main Takeaway

• Write programs to clean, filter, aggregate, restructure, and combine data.
• Load data from both structured and unstructured sources.
• Perform basic exploratory data analysis.
• Apply principles of scientific method and reproducible reporting to the development and presentation of code-based solutions.

Python Libraries that covered

• Sympy A Python library for symbolic mathematics
• Numpy A fundamental package for scientific computing with Python
• Pandas A fundamental package for scientific computing with Python
• Matplotlib A Python 2D plotting library
• Seaborn A Python data visualization library based on matplotlib
• Bokeh An interactive visualization library that targets modern web browsers for presentation
• Plotly An interactive, open-source, and browser-based graphing library
• Scikit-learn A free software machine learning library for the Python programming language.
• Request A free software machine learning library for the Python programming language.

Final Project: College Admission Analysis

Explore the relationship mainly between University Admission Rate and SAT Score but with different condition. The Dataset were collected under two method:

• College Scorecard Data(CSV file)
• States Population & Income Data(Website API)

Visualization Sample:

Steps

1. Modules Import
2. Import CSV & API Datasets
3. Exploratory Data Analysis(EDA)
4. Linear Regression Analysis
5. Draw Conclusion
6. Make a Mini-Chatbot: SAT for a School?

Contributor

• Qinghao Xia -GitHub
• Qihua Zhu - Portfolio