Data Exploration

  Introduction Renaming columns in both R and Python is simple.   The examples were inspired by Matt Dancho and his incredible library of training videos on  Business Science University .  In the R examples, we will be using the RStudio IDE.  It is assumed that you have a project set up in the folder where the data files exist. For more information about getting a project set up in R Studio and the Python environment set up in VS Code, click the links below. Setting Up Projects in R Setting Up Python VS Code Environment R: Rename Columns In the previous articles, we detailed how to perform the following functions listed below.  For more information, click on the links below. 01: Data Imports 02: Join Data 03: Change Data Types 04: String Splits 05: Calculate New Columns 06: Organize Columns  library(tidyverse) library(readxl) bikes <- read_excel( "00_Data_Files/bikes.xlsx" ) bikeshops <- read_excel( "00_Data_Files/bikeshops.xlsx...

  Introduction Organizing columns in both R and Python is straightforward.   The examples were inspired by Matt Dancho and his incredible library of training videos on  Business Science University .  In the R examples, we will be using the RStudio IDE.  It is assumed that you have a project set up in the folder where the data files exist. For more information about getting a project set up in R Studio and the Python environment set up in VS Code, click the links below. Setting Up Projects in R Setting Up Python VS Code Environment R: Organize Columns In the previous articles, we detailed how to perform the following functions listed below.  For more information, click on the links below. 01: Data Imports 02: Join Data 03: Change Data Types 04: String Splits 05: Calculate New Columns library(tidyverse) library(readxl) bikes <- read_excel( "00_Data_Files/bikes.xlsx" ) bikeshops <- read_excel( "00_Data_Files/bikeshops.xlsx" ) orderlines...

  Introduction Adding columns in both R and Python is pretty straightforward.   The examples were inspired by Matt Dancho and his incredible library of training videos on  Business Science University .  In the R examples, we will be using the RStudio IDE.  It is assumed that you have a project set up in the folder where the data files exist. For more information about getting a project set up in R Studio and the Python environment set up in VS Code, click the links below. Setting Up Projects in R Setting Up Python VS Code Environment R: Mutate (Add) Columns In the previous articles, we detailed how to perform the following functions listed below.  For more information, click on the links below. 01: Data Imports 02: Join Data 03: Change Data Types 04: String Splits library(tidyverse) library(readxl) bikes <- read_excel( "00_Data_Files/bikes.xlsx" ) bikeshops <- read_excel( "00_Data_Files/bikeshops.xlsx" ) orderlines <- read_excel(...

  Introduction Splitting strings based on a delimited is easy in both R and Python.   The examples were inspired by Matt Dancho and his incredible library of training videos on  Business Science University .  In the R examples, we will be using the RStudio IDE.  It is assumed that you have a project set up in the folder where the data files exist. For more information about getting a project set up in R Studio and the Python environment set up in VS Code, click the links below. Setting Up Projects in R Setting Up Python VS Code Environment R: Split Strings Based on Delimiter In the previous articles, we detailed how to perform the following functions listed below.  For more information, click on the links below. 01: Data Imports 02: Join Data 03: Change Data Types library(tidyverse) library(readxl) bikes <- read_excel( "00_Data_Files/bikes.xlsx" ) bikeshops <- read_excel( "00_Data_Files/bikeshops.xlsx" ) orderlines <- read_excel(...