Skip to content

Latest commit

 

History

History
37 lines (19 loc) · 785 Bytes

README.md

File metadata and controls

37 lines (19 loc) · 785 Bytes

Project Overview

Extract

-First we made the proper imports in Pandas

-Next we extraced the CVS's into pandas and displayed them

-Merged the two dataframes

-Listed the overall columns

Transform

-Made all the column names same capitalization for synchranization

-From the listed columns we dropped those not needed for our merged dataframe

-Added underscores in place of spaces in names for SQL purposes

-Ensured all D-types matched SQL designations

-Set index to ID

-Created schema for SQL

Load

-Create database connection

-Confirm tables in database

-Load DataFrames into Database


© 2021 Trilogy Education Services, LLC, a 2U, Inc. brand. Confidential and Proprietary. All Rights Reserved.