Aster Hu | R-bloggers

Analyzing every minutes of my spare time in R: 6 months of time tracking insights

September 17, 2023 | Aster Hu

I’ve always believed that how I spend my spare time will have an impact on my future. Based on this philosophy, I started tracking my spare time, which includes any time outside of sleep hours and my 9-5 work schedule. I now have over 6 months’ wo...

[Read more...]

Analyzing every minutes of my spare time in R: 6 months of time tracking insights

September 17, 2023 | Aster Hu

I’ve always believed that how I spend my spare time will have an impact on my future. Based on this philosophy, I started tracking my spare time, which includes any time outside of sleep hours and my 9-5 work schedule. I now have over 6 months’ w...

[Read more...]

Create interactive 2023 Toronto mayoral election map in R with leaflet

July 10, 2023 | Aster Hu

With the help of the internet and ChatGPT, I was able to create this interactive election map showing the top five candidates with the most votes in each ward. It took longer than expected, but it was fun to learn new things, such as working with JSON in R and ... [Read more...]

Create interactive 2023 Toronto mayoral election map in R with leaflet

July 10, 2023 | Aster Hu

With the help of the internet and ChatGPT, I was able to create this interactive election map showing the top five candidates with the most votes in each ward. It took longer than expected, but it was fun to learn new things, such as working with JSON in R and ... [Read more...]

The differences of left join in SQL and R

June 25, 2023 | Aster Hu

Recently, I encountered a situation where I needed to translate an Access SQL query to R, and I noticed the contrasting behaviors of these two languages when it comes to handling NA/NULL values in left joins. The impact of NA/NULL values on joins... [Read more...]

The differences of left join in SQL and R

June 25, 2023 | Aster Hu

Recently, I encountered a situation where I needed to translate an Access SQL query to R, and I noticed the contrasting behaviors of these two languages when it comes to handling NA/NULL values in left joins. The impact of NA/NULL values on joins... [Read more...]

The differences of left join in SQL and R

June 25, 2023 | Aster Hu

Recently, I encountered a situation where I needed to translate an Access SQL query to R, and I noticed the contrasting behaviors of these two languages when it comes to handling NA/NULL values in left joins. The impact of NA/NULL values on join... [Read more...]

Replace missing value from other columns using coalesce join in dplyr

May 10, 2023 | Aster Hu

The original coalesce function When cleaning and aggregating data using dplyr package in R, coalesce() is extremely handy to replace the NA value with values from other columns. A simple example How does coalesce() work originally? Below is a s...

[Read more...]

Replace missing value from other columns using coalesce join in dplyr

May 10, 2023 | Aster Hu

The original coalesce function When cleaning and aggregating data using dplyr package in R, coalesce() is extremely handy to replace the NA value with values from other columns. A simple example How does coalesce() work originally? Below is a s...

[Read more...]

Replace missing value from other columns using coalesce join in dplyr

May 10, 2023 | Aster Hu

dplyr The original coalesce function When cleaning and aggregating data using dplyr package in R, coalesce() is extremely handy to replace the NA value with values from other columns. A simple example How does coalesce() work originally? B...

[Read more...]

Alternatives of openxlsx when importing Excel to R

November 17, 2022 | Aster Hu

The problem of openxlsx At work, I rely on the R package openxlsx heavily and use openxlsx::read.xlsx to import excel spreadsheet, which is the most common format in business settings. Now here is the issue I discovered recently. I have a sp...

[Read more...]

Alternatives of openxlsx when importing Excel to R

November 17, 2022 | Aster Hu

The problem of openxlsx At work, I rely on the R package openxlsx heavily and use openxlsx::read.xlsx to import excel spreadsheet, which is the most common format in business settings. Now here is the issue I discovered recently. I have a sp...

[Read more...]

Alternatives of openxlsx when importing Excel to R

November 17, 2022 | Aster Hu

The problem of openxlsx At work, I rely on the R package openxlsx heavily and use openxlsx::read.xlsx to import excel spreadsheet, which is the most common format in business settings. Now here is the issue I discovered recently. I have a sprea...

[Read more...]

Course Review: Data Science with R

April 17, 2022 | Aster Hu

About the Course Course: Data Science with R Provider: Pluralsight Author: Matthew Renze Link: https://www.pluralsight.com/courses/r-data-science __ TL;DR: Jump to conclusion Structure The course consists of the following modules: Introduct...

[Read more...]

Course Review: Data Science with R

April 17, 2022 | Aster Hu

About the Course Course: Data Science with R Provider: Pluralsight Author: Matthew Renze Link: https://www.pluralsight.com/courses/r-data-science __ TL;DR: Jump to conclusion Structure The course consists of the following modules: Introduct...

[Read more...]

Course Review: Data Science with R

April 17, 2022 | Aster Hu

Data science with R About the Course Course: Data Science with R Provider: Pluralsight Author: Matthew Renze Link: https://www.pluralsight.com/courses/r-data-science __ TL;DR: Jump to conclusion Structure The course consists of the foll...

[Read more...]

R-bloggers

R news and tutorials contributed by hundreds of R bloggers

Articles by Aster Hu

Analyzing every minutes of my spare time in R: 6 months of time tracking insights

Analyzing every minutes of my spare time in R: 6 months of time tracking insights

Create interactive 2023 Toronto mayoral election map in R with leaflet

Create interactive 2023 Toronto mayoral election map in R with leaflet

The differences of left join in SQL and R

The differences of left join in SQL and R

The differences of left join in SQL and R

Replace missing value from other columns using coalesce join in dplyr

Replace missing value from other columns using coalesce join in dplyr

Replace missing value from other columns using coalesce join in dplyr

Alternatives of openxlsx when importing Excel to R

Alternatives of openxlsx when importing Excel to R

Alternatives of openxlsx when importing Excel to R

Course Review: Data Science with R

Course Review: Data Science with R

Course Review: Data Science with R

Articles by Aster Hu

Never miss an update! Subscribe to R-bloggers to receive e-mails with the latest R posts. (You will not see this message again.)

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)