Data Engineering - 8

Which function in which package stores the results of a SQL query directly in a data frame?

• read_csv, pandas

• read_sql, sqlalchemy

• read_sql, mysql.connector

• to_sql, sqlalchemy

Which are part of data cleaning?

• Creating new variables

• Handling incorrect data

• Handling missing values

• Renaming columns

Which are part of data transformation?

• Creating new variables/coulmns

• Converting variable types (e.g., string to date)

• Querying data

• Loading data into a table

In the data-cleaning process, all duplicate values must be removed 

• True

• False

Which is most efficient in a pipeline?

• Data is queried, cleaned, and transformed on an ongoing basis everytime it is needed for the analysis.

• Data is queried, cleaned, transformed, and loaded to the database in a new table. The new table is queried for further analysis.