gravatar

Seetz

Seetharam Indurti

Recently Published

Partitioning data into training and validation datasets using R
Illustrates developing linear regression model using training data and then making predictions using validation data set in r.
Introduction to R part 1
ABCDEcompany
IPL2017
IPL 2017 statistics
Assignment | SQL Orientation Topic Progress:Intro to RDBMS and SQL
Your assignment is to follow the same process which we followed during the session with sales file. You should use a different database for this. You can make use of the procedures learned in the session to copy diamonds data set (from R datasets) into Postgres database. Create a database in Postgres called new diamonds. Download the dataset from the link below https://vincentarelbundock.github.io/Rdatasets/csv/Ecdat/Diamond.csv Create a table in Postgres that matches the column names and formats. Hint- you can see type of column data by importing into Pandas data frame and using .info Now use the \copy command to copy the dataset from .csv to Postgres Use RODBC from within R to connect to the Postgres database and read 5 records from the diamond’s table in Postgres Use SQL Alchemy to connect Python to Postgres and read 5 records.