Pandas Cookbook

How it works...

1. Read in the movie dataset, and use the title of the movie to label each row. Use the get_dtype_counts method to output the number of columns with each specific data type:

>>> movie = pd.read_csv('data/movie.csv',                        index_col='movie_title')>>> movie.get_dtype_counts()float64    13
int64       3
object     11
dtype: int64

2. Use the select_dtypes method to select only the integer columns:

>>> movie.select_dtypes(include=['int']).head()

3. If you would like to select all the numeric columns, you may simply pass the string number to the include parameter:

>>> movie.select_dtypes(include=['number']).head()

4. An alternative method to select columns ...