Box And Whisker Plots

Avoid the annoying ...

pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)

Print table to terminal

print(df.head())

Read CSV

df.read_csv("file.csv")

Export to CSV

df.to_csv("file.csv")

Print a summary of the data

df.describe()

Show Columns

df.columns

Drop all missing values

df = df.dropna(axis=0)

Get dimensions of table

df.shape
>>(rows, columns)

Get number of instances per class

print(dataset.groupby('class').size())

Univariate Plotting

# Box and Whisker Plots
dataset.plot(kind='box', subplots=True, layout=(2,2), sharex=False, sharey=False)

# histograms
dataset.hist()

plt.show()