Creating graphs in R

Once a dataframe has been set up with the necessary column, we can begin to graph the data and explore visualization options.

Creating simple charts with plot() in R

The most basic graph can be generated with the plot() function using the following script:

plot(SQL_Query_1, main = 'Discount Code by Week') 

The output of the script can be seen here:

While the plot displays the discount by week, it is difficult to identify the relationship week-to-week without being able to connect the dots.

The following script will connect the dots between each sequential point:

plot(SQL_Query_1, main = 'Discount Code by Week', type="o") 

The output of the script can be seen in the following screenshot:

R has the ability to allow developers to combine multiple charts into a larger overall graph by using the par() function. If we choose to display two charts one above the other, we would create a matrix of two rows and one column by running the following script:

par(mfrow=c(2,1...