The Tutorials in this series are created using R3.0.0, 3.2.3, 3.4.4 on Mac OS and Ubuntu 16.04. R is a free, useful software package to anybody who wishes to undertake extensive statistical computations (a user community that includes students, researchers and professionals belonging to various disciplines). Read more
Foss : R - English
Outline: What is an R script Features of an R script How to create and save an R script from the user interface (UI) of RStudio Shortcut keys to create an R script How to use auto-com..
Outline: What is working directory in R How to know the current working directory How to use getwd function How to set a working directory from the user interface of RStudio How to set..
Outline: Shortcut key for assignment operator (<-) How to perform numeric indexing How to extract a row or column from a data frame How to retrieve multiple rows from a data frame How ..
Outline: Data required in a matrix format Convert a data frame into a matrix Create a matrix with known data Add two matrices Subtract two matrices Multiply two matrices elementwise..
Outline: How to find the inverse of a matrix How to calculate the sum of elements in a matrix using for loop How to calculate the sum of elements in a matrix using the sum function How..
Outline: Use of built-in functions in R for exploring a data frame Access help in RStudio Advantages of merging data frames Merge two data frames Import data from command line Impor..
Outline: What is an object in R Types of R - objects What is an atomic vector in R Types of atomic vectors How to find types of vectors Factors in R Levels of a factor in R Identi..
Outline: Lists in R Atomic vectors in R Difference between atomic vectors and lists in R How to create a list How to assign names to the elements of a list Named list in R How to..
Outline: How to find the dimensions of a data frame Define a histogram Plot a histogram in R Add labels to the histogram Add color to the bins of a histogram Change the number of b..
Outline: What is a bar chart Draw a bar chart Use the barplot function Add labels to the bar chart Adjust the labels of the bar chart What is a scatter plot Draw a scatter plot Use ..
Outline: Define visualization About grammar of graphics- ggplot2 Use of the plot function Add labels to a plot Change the color and type of plot Plot two graphs in the same plot Add..
Outline: Define aesthetic Need for aesthetic in plotting Draw a scatter plot Customize a scatter plot View the structure of an object View the levels of a categorical variable Dr..
Outline: What is data visualization Need for data manipulation What is dplyr package Functions in dplyr package Install dplyr package Use filter function Use filter function wit..
Outline: Functions in the dplyr package Select multiple variables in a data frame Remove variables from a data frame Use of select function Use of starts_with function Change the ..
Outline: About summarise function in dplyr About group_by function in dplyr Difference between summarise and group_by functions Use summarise and group_by functions together About pip..
Outline: About conditional statements Syntax of if, else and else if statements Use if, else and else if statements Use if else function Arguments of if else function Add a new column ..
Outline: Define a function About built-in functions and user-defined functions Need for a user-defined function Syntax of a function Parts of a function Create a user-defined functio..
Foss : RDBMS PostgreSQL - English
Outline: Introduction to RDBMS Common Software based on RDBMS Prerequisites for learning PostgreSQL OS and PostgreSQL version used Features of PostgreSQL Who can use PostgreSQL? Glimp..
Outline: Installation of PostgreSQL on Linux Installation of PostgreSQL on Windows Installation of pgAdmin Connect to PostgreSQL database Set Password for the database Disconnect from ..
Outline: How to connect to the server Introduction to database and its objects How to create a database Table and its attributes pgAdmin interface. New server registration How to crea..