SQLDF package - WHERE operation (SQL Queries in R #2)
In this tutorial series “SQL Queries in R” we will be looking at few of the most commonly used SQL queries/operations and will try to implement them in R using packages such as SQLDF. In this video, the WHERE operation is explored.
For similar videos on data analysis and visualization, check out the links attached:
Data Visualization Basics tutorial series:
https://tinyurl.com/data-viz-basics-in-R
Data Analysis Basics in R tutorial series:
https://tinyurl.com/data-analysis-bas...
Intermediate Data Analysis in R tutorial series:
https://tinyurl.com/intermediate-data...
----------------------------------------
Other related videos/links:
SQL in R
SQLDF package - SELECT operation: • SQLDF package - SELECT operation (SQL Que...
Intermediate Data Analysis in R
FOR Loop: • Basic FOR Loops (Intermediate Data Analysi...
WHILE Loop: • Basic WHILE Loops (Intermediate Data Analy...
REPEAT Loop: • Basic REPEAT Loops (Intermediate Data Anal...
NESTED FOR Loop: • Simple nested FOR LOOPs (Intermediate Data...
loop through dataframes: • Loop through data frames (Intermediate Dat...
Sequence with increments: • Sequence with increments (Intermediate Dat...
Adding columns using mutate and transmute (dplyr): • dplyr package - mutate and transmute (Inte...
Subsetting rows and columns using filter and select (dplyr): • dplyr package – select and filter (Interme...
Subsetting rows using slice function (dplyr): • dplyr package – slice function for subsett...
Summarize and arrange: • dplyr package – summarize and arrange (Int...
Number and size of groups: • dplyr package – number and size of groups ...
----------------------------------------
Data Visualization Basics in R
Intro to plotting using qplot in R: • Plotting in R using qplot function within ...
Histogram and boxplot in R: • Histogram and boxplot in R using qplot fun...
Add or change legend names while using qplot: • Add or change legend names while using qpl...
Change scatter plot colors in R manually: • Change scatter plot colors in R manually (...
Saving plots as .JPEG / .PNG: • Saving Plots in R as .JPEG / .PNG files (D...
Error bars for bar plots: • Plotting in R using ggplot2: Error bars fo...
Adjusting geom positions while using ggplot2 package: • Plotting in R using ggplot2: Adjusting geo...
Adding plot labels: • Plotting in R using ggplot2: Adding plot l...
Remove legend and legend titles: • Plotting in R using ggplot2: Remove legend...
Create custom color palette: • Plotting in R using ggplot2: Create custom...
Plot multiple plots: • Plotting in R using ggplot2: Plotting mult...
----------------------------------------
Data Analysis Basics in R
Setting a working directory in R Studio: • How to set working directory in R Studio (...
Data structures in R: • Types of data structures in R (Data Analys...
Create a dataframe in R: • How to create a dataframe in R (Data Analy...
Install packages in R: • How to install packages in R Studio (Data ...
How to import .csv file in R: • How to import csv file in R Studio (Data A...
How to add a column in R: • How to add a column in R (Data Analysis Ba...
How to remove a row in R: • How to remove a row in R dataframes (Data ...
Count the number of rows and columns in R: • How to find out the number of rows and col...
Sum of rows in R: • How to calculate sum of rows in R datafram...
Sum of columns in R: • How to calculate sum of columns in R dataf...
Finding names of rows and columns in R: • How to find column and row names in R Stud...
How to change column names in R dataframes: • How to change column names in R dataframes...
How to remove rows with 0 values in R dataframes: • How to remove rows with 0 values in R data...
How to find unique column values in R dataframes: • How to find unique column values in R data...
----------------------------------------
GIS/Remote Sensing
Intro to GIS and Remote Sensing: • What is Remote Sensing and GIS?
What is LiDAR Remote Sensing: • What is LiDAR? A Quick Introduction (Lidar...
Intro to spaceborne lidar and NASA GEDI: • Spaceborne LiDAR and NASA Global Ecosystem...
LiDAR Remote Sensing/NASA GEDI Tutorial Series: • What is LiDAR? A Quick Introduction (Lidar...
----------------------------------------