YoVDO

Using Python for Data Management and Reporting

Offered By: A Cloud Guru

Tags

Python Courses Data Visualization Courses SQL Courses MongoDB Courses pandas Courses Jupyter Notebooks Courses Data Management Courses

Course Description

Overview

Data abounds in our world. It is collected in various forms, various ways, and various qualities. It is collected for a multitude of purposes, including collecting for some undefined future use. Being able to access that data and make some sense of it is an important skill for now and the future.Python is an excellent resource for exploring data and making it usable for a variety of purposes. Using Python and Jupyter Notebooks, we will look at accessing data in some common databases, such as MySQL, PostgreSQL, and MongoDB. We will explore Excel operations, such as writing and reading to Excel. We will also explore simple report formatting and data visualization.

Syllabus

  • Overview
  • Using Jupyter Notebooks
  • panda DataFrames in Jupyter Notebooks
  • SQL Python Database Packages
  • MongoDB Package: pymongo
  • Delimited Data Text Files
  • Excel Data Files
  • Writing the Report
  • Conclusion

Taught by

Larry Fritts

Related Courses

Introduction to Data Science in Python
University of Michigan via Coursera Julia Scientific Programming
University of Cape Town via Coursera Python for Data Science
University of California, San Diego via edX Probability and Statistics in Data Science using Python
University of California, San Diego via edX Introduction to Python: Fundamentals
Microsoft via edX