M6S1 Flashcards
1
Q
Process of converting raw data into a usable form
A
Data Wrangling
2
Q
Also called as data mugging or data remediation.
A
Data Wrangling
3
Q
Data Wrangling Steps
A
- Discovery
- Transformation
- Validation
- Publishing
4
Q
Data examination for next step
A
Discovery
4
Q
Data structuring, normalization, & denormalization, data cleaning, data enriching
A
Transformation
5
Q
verifying data consistency, sufficient quality, and secure
A
Validation
6
Q
Preferred format for sharing with teammates.
A
Publishing
7
Q
Library that provides several functions for loading dataset.
A
Pandas
8
Q
Data structure that holds input datasets
A
DataFrame
9
Q
Comma-Separated Values (CSV)
A
- Tabular Format
- Very lightweight
- May not be easy to read visually
10
Q
CSV to DataFrame
A
pandas.read_csv(filename.csv)
11
Q
What reads the text file into chunks?
A
pandas.io.parsers.TextFileReader
12
Q
Load and read Excel file
A
- pandas.io.excel._base.ExcelFile
- pandas.ExcelFile(‘<Excel>')</Excel>
- pandas.read_excel(<ExcelFile>, '<sheet>')</sheet></ExcelFile>
13
Q
Directly Read Excel File
A
- pandas.read_excel(‘<Excel>', '<sheet>')</sheet></Excel>
