Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

A Cloud Guru

Using Python for Data Management and Reporting

via A Cloud Guru

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

Reviews

Start your review of Using Python for Data Management and Reporting

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.