storing scorecards

/in /by

You are working as a software programmer. You need to write a prepare a database table to store the scorecard element of the different cohorts.

Using the attached CSV file, create a Python script that should perform following tasks.

  • Create a SQLite table with following columns as described in the csv file and name it as Cohorts table
  • Insert data into the SQLite table
  • Store the data into the Pandas DataFrame
  • Print the result using read_sql statement.

For your submission, include the following:

  • Attach a Python script.
  • An output screenshot.