(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – RDBMS The data is Relational database systems are stored in a normalized format. So, to carry out statistical computing we will need very advanced and complex Sql queries. But R can connect easily to many relational databases like MySql, Oracle, Sql server etc. and …
Day: December 28, 2020
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – How to load an Excel File Microsoft Excel is the most widely used spreadsheet program which stores data in the .xls or .xlsx format. R can read directly from these files using some excel specific packages. Few such packages are – XLConnect, xlsx, gdata …
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – How to load CSV Files In R, we can read data from files stored outside the R environment. We can also write data into files which will be stored and accessed by the operating system. R can read and write into various file formats …
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – Data Reshaping Data Reshaping in R is about changing the way data is organized into rows and columns. Most of the time data processing in R is done by taking the input data as a data frame. It is easy to extract data from …
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – Data Frames A data frame is a table or a two-dimensional array-like structure in which each column contains values of one variable and each row contains one set of values from each column. Following are the characteristics of a data frame. The column names …
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – Factors Factors are the data objects which are used to categorize the data and store it as levels. They can store both strings and integers. They are useful in the columns which have a limited number of unique values. Like “Male, “Female” and True, …
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – Arrays Arrays are the R data objects which can store data in more than two dimensions. For example − If we create an array of dimension (2, 3, 4) then it creates 4 rectangular matrices each with 2 rows and 3 columns. Arrays can …
(R Tutorials for Citizen Data Scientist) Beginners tutorial with R – Matrices Matrices are the R objects in which the elements are arranged in a two-dimensional rectangular layout. They contain elements of the same atomic types. Though we can create a matrix containing only characters or only logical values, they are not of much use. …