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

Design Computing: 3D Modeling in Rhinoceros with Python/Rhinoscript
University of Michigan via Coursera 3D SARS-CoV-19 Protein Visualization With Biopython
Coursera Project Network via Coursera A Simple Scatter Plot using D3 js
Coursera Project Network via Coursera Access Bioinformatics Databases with Biopython
Coursera Project Network via Coursera Accounting Data Analytics
University of Illinois at Urbana-Champaign via Coursera