SQLDF package - SELECT operation (SQL Queries in R #1)

Описание: 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 first video, the SELECT 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:


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...  

----------------------------------------