This post states the steps to connect R with SQL Server, so that we can directly access tables and can do analysis on data stored in SQL Server. System Related Settings1. Go to Control panel of your system. 2. Click on Administrative tools 3. Select User dsn -> click on “add” -> “Sql server” 4. […]
Connect R with SQL Server Read More »
Missing value or junk value imputation with mean/median/mode is the very basic part of data cleaning , as these processes will give the accuracy up to a certain level. Also if mean/median/mode are applicable when our data is in some traditional format, but in most of the practical scenario it is not. If our data
Missing Value imputation – advanced way Read More »
Every programming language should have the facility of file handling. At least basic open, close, read, and write file records. To access the file we have two options in python. One obviously to give the whole path in every file operations and another and the best one should be set your path of the files
File and string handling in Python Read More »
