How do I find numeric columns in Pandas

Question

Let s say df is a pandas DataFrame  I would like to find all columns of numeric type  Something like   isNumeric   is numeric df

User · Answer

Please see the below code   if dataset select dtypes include  np number   shape 1   gt  0   display dataset select dtypes include  np number   describe    if dataset select dtypes include  np object   shape 1   gt  0   display dataset select dtypes include  np object   describe      This way you can check whether the value are numeric such as float and int or the srting values  the second if statement is used for checking the string values which is referred by the object

User · Answer

Simple one-liner   df select dtypes  number   columns

User · Answer

Adapting this answer  you could do  df ix   df applymap np isreal  all axis 0     Here  np applymap np isreal  shows whether every cell in the data frame is numeric  and  axis all 0  checks if all values in a column are True and returns a series of Booleans that can be used to index the desired columns

User · Answer

You can use the undocumented function  get numeric data   to filter only numeric columns   df  get numeric data     Example   In  32   data Out 32      A  B 0  1  s 1  2  s 2  3  s 3  4  s  In  33   data  get numeric data   Out 33      A 0  1 1  2 2  3 3  4   Note that this is a  private method   i e   an implementation detail  and is subject to change or total removal in the future  Use with caution

User · Answer

We can include and exclude data types as per the requirement as below   train select dtypes include None  exclude None  train select dtypes include  number    will include all the numeric types   Referred from Jupyter Notebook   To select all numeric types  use np number or  number    To select strings you must use the object dtype but note that this will return all object dtype columns See the NumPy dtype hierarchy  lt http   docs scipy org doc numpy reference arrays scalars html gt    To select datetimes  use np datetime64   datetime  or  datetime64  To select timedeltas  use np timedelta64   timedelta  or  timedelta64  To select Pandas categorical dtypes  use  category  To select Pandas datetimetz dtypes  use  datetimetz   new in 0 20 0  or    datetime64 ns  tz

User · Answer

Following codes will return list of names of the numeric columns of a data set   cnames list marketing train select dtypes exclude   object    columns    here marketing train is my data set and select dtypes   is function to select data types using exclude and include arguments and columns is used to fetch the column name of data set         output of above code will be following     custAge         campaign         pdays         previous         emp var rate         cons price idx         cons conf idx         euribor3m         nr employed         pmonths         pastEmail     Thanks

User · Answer

You could use select dtypes method of DataFrame  It includes two parameters include and exclude  So isNumeric would look like   numerics     int16    int32    int64    float16    float32    float64    newdf   df select dtypes include numerics

User · Answer

Simple one-line answer to create a new dataframe with only numeric columns   df select dtypes include np number    If you want the names of numeric columns   df select dtypes include np number  columns tolist     Complete code   import pandas as pd import numpy as np  df   pd DataFrame   A   range 7  10                       B   np random rand 3                       C     foo   bar   baz                        D     who   what   when     df      A         B    C     D   0  7  0 704021  foo   who   1  8  0 264025  bar  what   2  9  0 230671  baz  when  df numerics only   df select dtypes include np number  df numerics only      A         B   0  7  0 704021   1  8  0 264025   2  9  0 230671  colnames numerics only   df select dtypes include np number  columns tolist   colnames numerics only     A    B

User · Answer

df select dtypes exclude     object     Update  df select dtypes include  np number   or with new version of panda  df select dtypes  number

User · Answer

def is type df  baseType       import numpy as np     import pandas as pd     test    issubclass np dtype d  type  baseType  for d in df dtypes      return pd DataFrame data   test  index   df columns  columns     test    def is float df       import numpy as np     return is type df  np float  def is number df       import numpy as np     return is type df  np number  def is integer df       import numpy as np     return is type df  np integer

User · Answer

This is another simple code for finding numeric column in pandas data frame   numeric clmns   df dtypes df dtypes     object   index

[python] How do I find numeric columns in Pandas?

Examples related to python

Examples related to types

Examples related to pandas