Column types

You can glean information about the data in pandas simply by looking at the types of the columns. In this recipe, we will explore the column types.

How to do it…

1. Inspect the .dtypes attribute:

   >>> fueleco.dtypes
   barrels08     float64
   barrelsA08    float64
   charge120     float64
   charge240     float64
   city08          int64
                  ...    
   modifiedOn     object
   startStop      object
   phevCity        int64
   phevHwy         int64
   phevComb        int64
   Length: 83, dtype: object
   

2. Summarize the types of columns:

   >>> fueleco.dtypes.value_counts()
   float64    32
   int64      27
   object     23
   bool        1
   dtype: int64
   

How it works…

When you read a CSV file in pandas, it has to infer the types of the columns. The process looks something like this:

• If all of the values in a column look like whole numeric values, convert them to integers and give the column the type int64
...