Cheatsheet

Libraries/tools

• numpy
• pandas
• matplotlib + seaborn
• sql
• Excel
• BI Tools
• Node_js

SOP

• Data Preparation: preparing data for ingestion into a data processing stream.
  • df['Identifier'].is_unique
  • df.set_index('Identifier', inplace=True)
  • df.get_dtype_counts()
  • regular expression to extract our cleaned values
• Normalizing data sets, which generally means scaling the data to values.
  • Convert to numerics