Tableau, Excel, PowerBI, Python pre-processing expertise.

Based in Los Angeles, CA

5001 Python Preprocessing: Examining Column Data

Data Analysis with Python    

Python has the packages Pandas and Numpy to help examine column data:

Methods for examining column data using the Pandas library.

 

 

 

 

5002 Python Dummy Variables

Data Analysis with Python    

Using Dummy Variables and Python Pandas:

Perform Regression Analysis by using Dummy Variables to assign values to Categorical Variables.

 

 

 

 

5003 Python Multicollinearity and Classification

Data Analysis with Python    

How to avoid multicollinearity in Regression Analysis.

Using .loc[] and .max() to group dummy variables.

 

 

 

 

5004 Python - Concatenate, Rename, & Reorder Columns

Data Analysis with Python    

Rename and reorder columns.

Concatenation to combine data frames and columns using pd.concat().

 

 

 
     
 

Michael Pomeroy, MBA (owner/manager)

(310) 597-9907

Michael@ExcelXperts.com

©2019 ExcelXperts