Welcome to my 2nd repository! I am Pok, a student from the University of Auckland who is learning R, Markdown, SQL, Python and Java language now.

Recently, I have just created a new batch file rename program. The link for the program is HERE. It is highly appreciated if you can give me some feedback on the program.

After finishing the first half of my 2nd year school study, I would like to create this repository to conclude what I have learnt in the last semester.

In this repository, you can find the all the assignments from the course Stats 220 in which I acquired skills in R, Markdown and SQL language.

Please click on the navigation bar above to check my assignments out!

Assignment No. Achievements
1A * Understood how to implement simple markdown commands
* Learnt how to use the R {magick} package
1B * Understood how to create an html from Rmd file
2 * Understood how to set up questionnaire from Google Forms
* Learnt how to import data from Google Forms to R
* Learnt how to introduce dynamic reporting system in R Markdown
* Analysed data and created bar charts from {ggplot} package
3 * Learnt how to interact with Google Books API
* Created new dataframe in R from Google Books’ data
* Used {RSQLite} to extract desired data from a database
4 * Further used {ggplot} package to plot different types of charts
* Understood how to use codes from {tidyverse} to manipulate data
5 * Learnt how to scrape data from websites