Data can be downloaded from here
https://archive.ics.uci.edu/ml/datasets/wine+quality
In the preview data, use “First row is header” to identify the column name & “ Infer Schema” to automatically identify the data types.
The table will be created in Default database
Let’s crate a new database and load data into the table
Create a SQL Notebook and Import that downloaded data.
Some sample useful SQL commands
You can change to plot view
Using Python Notebook
Create a data frame and load the data from the table
Some common useful Python commands
Save the results as another table
Cleaning Data
Handling NULL value
Remove extreme values or outliers
Machine Learning
Create multiple charts and dashboards
Cheers!
Uma
No comments:
Post a Comment