Profile Data Using the pandas_profiling Python Package

The Scenario

You are working as a database admin, and after previously getting involved in a coworker's dispute, the validity of a data file containing U.S. Census data is being questioned. You certainly are not a Census expert, but you have recently learned about the pandas_profiling package from the awesome courses on acloud.guru. The information provided in a profile report may be just what is needed to resolve the questions. Since the report is available in an HTML format, you can start a quick HTTP server on your workstation to provide access to the report. You quickly return to your workstation to complete the following objectives:

• Install pandas_profiling.
• Load the CSV file into a DataFrame.
• Generate the report and save to a file.
• Start a simple web server on port 8080.

After you complete the above objectives, you can send your coworkers the following link to access the report: http://PUBLIC_IP:8080/profile_report.html.

Log in to the server over SSH using the credentials provided.

The data.csv file is already available in your workstation (the lab instance), but if you'd like to follow along on another machine, you can download it from here.

The data was sourced from the Center for Machine Learning and Intelligent Systems. Learn more here.