show all value types of columns code example
Example 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()
Example 2: pandas check if column is object type
for y in agg.columns:
if(agg[y].dtype == np.float64 or agg[y].dtype == np.int64):
treat_numeric(agg[y])
else:
treat_str(agg[y])