Exploring data with built in SQL translations
This section corresponds to use-case 4. Exploring the data.
The nzpyida package builds on top of the ibmdbpy package
and supports several built-in Pandas style data frame operations, which you can benefit from.
For more details, see this page.
- idadf.head()
- Returns the first n rows:
- idadf.describe()
- Various statistics on the columns:
- idadf.corr()
- Pairwise correlation of columns:
The code snippet generates a visual heat map by using the correlation values, just like a local pandas
df.corr().