1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Databases in Python

Exercise

ResultsSets and pandas DataFrames

We can feed a ResultSet directly into a pandas DataFrame, which is the workhorse of many Data Scientists in PythonLand. Jason demonstrated this in the video. In this exercise, you'll follow exactly the same approach to convert a ResultSet into a DataFrame.

Instructions

100 XP
  • Import pandas as pd.
  • Create a DataFrame df using pd.DataFrame() on the ResultSet results.
  • Set the columns of the DataFrame df.columns to be the columns from the first result object results[0].keys().
  • Print the DataFrame.