Using Python for Data Management and Reporting

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.

• 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