Economics Basics: A Tutorial

After reading this article , you will get clear understanding of economics basics.

1   Introduction to economics basics

Economics may appear to be the study of complicated tables and charts, statistics and numbers. However, more specifically, it is the study of what constitutes rational human behavior in the endeavor to fulfill needs and wants. Read more Economics Basics: A Tutorial

Import data from SQL server into R using RJDBC package

This tutorial talks about how to import data from SQL server into R using RJDBC package.

About the package

RJDBC is a package implementing DBI in R on the basis of JDBC. This allows the use of any DBMS in R through the JDBC interface. The only requirement is working Java and a JDBC driver for the database engine to be accessed.

Environment

  • Windows 7, 64-bit
  • R 2.15.1 (32- & 64-bit)
  • Microsoft SQL Server 2008

Read more Import data from SQL server into R using RJDBC package

Import Data From SQL Server Into R Using RODBC Package

This tutorial talks about how to import data from SQL server to R using RODBC package.

The functions provided by the RODBC package can be categorized into two groups:

  1. The mainly internal odbc* functions implement low-level access to the ODBC functions of similar name.
  2. The sql* functions operate at a higher level to read, save, copy and manipulate data between data frames and SQL tables

Read more Import Data From SQL Server Into R Using RODBC Package

Import data from Excel into R using RODBC package

This tutorial talks about how to import data from Excel into R using the RODBC package.

The R’s RODBC package is generally used to import data from SQL database into R. However, this package can also be used to import data from Excel into R.

The functions provided in the RODBC package can be categorized into two groups:

  1. The mainly internal odbc* functions:  implement low-level access to the ODBC functions of similar name.
  2. The sql* functions: operate at a higher level to read, save, copy and manipulate data between data frames and SQL tables Read more Import data from Excel into R using RODBC package

Configure Eclipse for R, both 32- and 64-bit

This tutorial talks about how to configure Eclipse for R, working simultaneously for both 32-bit and 64-bit versions. This is useful if we have both versions of R installed in computer.

For example, we may have the 64-bit R as the default configuration. Now we want to run the odbcConnectExcel function, but this function works only under 32-bit scenary. Therefore, we have to switch the current active configuration to 32-bit R.

Read more Configure Eclipse for R, both 32- and 64-bit

Eclipse as IDE for R Programming

In this tutorial, a step-by-step instruction is presented about how to use Eclipse as IDE for R programming,  through StatET, the specific plugin for R language.

Background

Eclipse is an open source Integrated Development Environment (IDE). As with Microsoft’s Visual Studio product, Eclipse is programming language-agnostic and supports any language having a suitable plugin for the IDE platform. The Eclipse’s plugin for R language is StatET.

Read more Eclipse as IDE for R Programming