Chapter 3. Learning What Your Data Truly Holds

Now that we have a clean dataset to work with, we'll look at the next phase of business intelligence—exploring the data. In this chapter, we will cover:

  • Creating Pandas DataFrames
    • Creating a Pandas DataFrame from a MongoDB query
    • Creating a Pandas DataFrame from a CSV file
    • Creating a Pandas DataFrame from an Excel file
    • Creating a Pandas DataFrame from a JSON file
  • Creating a data quality report
  • Generating summary statistics
    • For the entire dataset
      • Generating summary statistics for the entire dataset
      • Generating summary statistics for object type columns
      • Getting the mode of the entire dataset
    • For a single column
      • Generating summary statistics for a single column
      • Getting a count of unique values for a single column
      • Getting ...

Get Python Business Intelligence Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial