Once a dataframe has been set up with the necessary column, we can begin to graph the data and explore visualization options.
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: