Answers for "how to check the data types of columns in pandas"

1

python: check type and ifno of a data frame

df.shape
df.info()
df.dtypes
des = df.describe()                        # Summary
des_num = df.describe(include=[np.number]) # Include only numerical columns
des_obj = df.describe(include=[np.object]) # Include only string columns
des_obj.transpose()

# Show list of variable / columns in DF
df.columns

# Count number of variables / columns in DF
len(df.columns)

# Count variable
df["myvar"].value_counts()
Posted by: Guest on July-15-2020
1

get columns by type pandas

In [2]: df = pd.DataFrame({'NAME': list('abcdef'),
    'On_Time': [True, False] * 3,
    'On_Budget': [False, True] * 3})

In [3]: df.select_dtypes(include=['bool'])
Out[3]:
  On_Budget On_Time
0     False    True
1      True   False
2     False    True
3      True   False
4     False    True
5      True   False

In [4]: mylist = list(df.select_dtypes(include=['bool']).columns)

In [5]: mylist
Out[5]: ['On_Budget', 'On_Time']
Posted by: Guest on November-23-2020
1

how to find the datatype of a dataframe in python

df.dtypes
Posted by: Guest on May-20-2020

Code answers related to "how to check the data types of columns in pandas"

Python Answers by Framework

Browse Popular Code Answers by Language