Publications by Ramnivas Singh
Project 1 - Data Analysis
Problem Statement In this project, you’re given a text file with chess tournament results where the information has some structure. Your job is to create an R Markdown file that generates a .CSV file (that could for example be imported into a SQL database) with the following information for all of the players: Player’s Name, Player’s State...
5094 sym R (7806 sym/31 pcs) 3 img
data607-assignment3 : Character manipulation & Data processing
Overview #1. Using the 173 majors listed in fivethirtyeight.com’s College Majors dataset [https://fivethirtyeight.com/features/the-economic-guide-to-picking-a-college-major/], provide code that identifies the majors that contain either “DATA” or “STATISTICS” #2 Write code that transforms the data below: [1] “bell pepper” “bilberr...
3188 sym R (1673 sym/11 pcs)
data606-lab3
Initial data load glimpse(kobe_basket) ## Rows: 133 ## Columns: 6 ## $ vs <fct> ORL, ORL, ORL, ORL, ORL, ORL, ORL, ORL, ORL, ORL, ORL, ... ## $ game <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1... ## $ quarter <fct> 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3... ## $ time <fct> 9:47, 9:...
11111 sym R (1705 sym/20 pcs) 6 img
data607-assignment2-rds
Overview Choose six recent popular movies. Ask at least five people that you know (friends, family, classmates, imaginary friends if necessary) to rate each of these movies that they have seen on a scale of 1 to 5. Take the results (observations) and store them in a SQL database of your choosing. Load the information from the SQL database into an...
4685 sym R (7584 sym/18 pcs) 4 img
data607-assignment2 : Tidyverse
Overview Task here is to Create an example. Using one or more TidyVerse packages, and any dataset from fivethirtyeight.com or Kaggle, create a programming sample “vignette” that demonstrates how to use one or more of the capabilities of the selected TidyVerse package with your selected dataset. I picked up ‘COVID-19 World Vaccination Progre...
1881 sym R (12190 sym/21 pcs) 2 img
data607-assignment2 : Movie Ratings
Overview Choose six recent popular movies. Ask at least five people that you know (friends, family, classmates, imaginary friends if necessary) to rate each of these movies that they have seen on a scale of 1 to 5. Take the results (observations) and store them in a SQL database of your choosing. Load the information from the SQL database into an...
4685 sym R (7297 sym/18 pcs) 4 img
Data607-Assignment1
Overview Mushroom Data Set This data set sourced from the UCI repository of machine learning databases. Hypothetical samples corresponding to 23 species of gilled mushrooms in the Agaricus and Lepiota family are categorized as either poisonous or edible based on physical attributes. More information is available at Mushroom Data Set Repository li...
1509 sym R (9103 sym/37 pcs)
Data606-Lab1_intro_to_R
The RStudio Interface The goal of this lab is to introduce you to R and RStudio, which you’ll be using throughout the course both to learn the statistical concepts discussed in the course and to analyze real data and come to informed conclusions. To clarify which is which: R is the name of the programming language itself and RStudio is a conven...
17489 sym R (8450 sym/61 pcs) 9 img
Tutorial : R and MySQL integration
Summary This document is to provide steps for R & SQL integration. MySQL database is used for this setup. Setup MySQL instance MySQL Server 8.0 setup Setup MySQL Server with default settings. Remember to copy root user/password for later uses. MySQL Server Workbench setup MySQL components after MySQL components and Workbench install Path u...
3228 sym R (3003 sym/8 pcs) 27 img
Data606-Lab2_intro_to_data
Initial data load data(nycflights) names(nycflights) ## [1] "year" "month" "day" "dep_time" "dep_delay" "arr_time" ## [7] "arr_delay" "carrier" "tailnum" "flight" "origin" "dest" ## [13] "air_time" "distance" "hour" "minute" glimpse(nycflights) ## Rows: 32,735 ## Columns: 16 ## $ year <int> 2013, ...
11927 sym R (6818 sym/32 pcs) 7 img