Pandas | Basics | Priority

Question 1

How to convert text into 0/1 for machine learning.

Machine Learning with PyTorch and Scikit-Learn Chapter 9 p273

Answer 1

df[‘Central Air’] = df[‘Central Air’].map({‘N’: 0, ‘Y’: 1})

Machine Learning with PyTorch and Scikit-Learn Chapter 9 p273

Question 2

Check whether any of the data frame columns contain missing values.

Machine Learning with PyTorch and Scikit-Learn Chapter 9 p273

Answer 2

df.isnull().sum()

Machine Learning with PyTorch and Scikit-Learn Chapter 9 p273

Question 3

Remove rows with missing values.

Machine Learning with PyTorch and Scikit-Learn Chapter 9 p273

Answer 3

df = df.dropna(axis=0)

Machine Learning with PyTorch and Scikit-Learn Chapter 9 p273

Question 4

Pandas series idioms for histogram, boxplot, kernel density plot, line plot?

Effective Pandas 14. Plotting with a Series

Answer 4

df[‘series_name’].plot.hist()/box()/kde()/line()

Question 5

Pandas function to convert a multiindex to columns.

Effective Pandas 14. Plotting with a Series

Answer 5

unstack()

Question 6

Pandas idiom to get percentages from a series.

Effective Pandas 14. Plotting with a Series

Answer 6

“(season2017
.resample(‘M’)
.sum()
.div(season2017.sum())
.mul(100))”