Chuliang Xiao

Research Fellow

University of Michigan

Biography

I am a Senior Data Analytics Engineer at Priority Health, part of Spectrum Health System in Grand Rapids. Before this, I was a hydrological modeler at the University of Michigan’s Cooperative Institute for Great Lakes Research (CIGLR) working at the National Oceanic and Atmospheric Administration (NOAA) Great Lakes Environmental Research Laboratory (GLERL) in Ann Arbor, Michigan.

Interests

Data Analytics
Machine Learning
Database Development

Education

PhD in Atmpsheric Sciences, 2013

Nanjing University
BSc in Atmpsheric Sciences, 2008

Nanjing University

Selected Publications

Improving the lake scheme within a coupled WRF-Lake model in the Laurentian Great Lakes

In regional climate models, how to resolve lake surface temperature is crucial to understanding the hydroclimate in water-dominated regions, i.e. the Great Lakes basin. If no lake model is implemented in the lake grids, a “search” option will be employed to extrapolate lake surface temperature from the closest water point with valid data, e.g. Hudson Bay and the Atlantic Ocean, which can cause obvious biases and even adverse effects. In this study, a one-dimensional thermal diffusion lake model within the Weather Research and Forecasting model is updated with a specific treatment of lake surface albedo for the Laurentian Great Lakes to improve the coupled air-lake model’s performance in the simulation of lake temperature and lake ice.

C Xiao, BM Lofgren, J Wang, PY Chu

In Journal of Advances in Modeling Earth Systems, 2016

PDF Project View Journal Article

Recent Publications

More Publications

Chuliang Xiao, Brent M. Lofgren , Jia Wang , Philip Y. Chu. A Dynamical Downscaling Projection of Future Climate Change in the Laurentian Great Lakes Region Using a Coupled Air-Lake Model. In Atmosphere, 2018.

PDF View Journal Article

Chuliang Xiao, Brent M. Lofgren , Jia Wang , Philip Y. Chu. WRF-based assessment of the Great Lakes' impact on cold season synoptic cyclones. In Atmospheric Research, 2018.

View Journal Article

U. Charusombat et al.. Evaluating and improving modeled turbulent heat fluxes across the North American Great Lakes. In Hydrology and Earth System Sciences Discussion, 2018.

PDF View Journal Article

Recent & Upcoming Talks

West Michigan Big Data Meetup

Feb 21, 2018 6:00 PM

Meetup

Project

Implementing the WRF-Hydro Modeling System in the Great Lakes Region

Jan 9, 2018 2:00 PM

AMS 2018

Project

Recent Posts

Change R (Rscript) Windows Environment Path from OneDrive

pain in the butt When OneDrive was installed in a computer, it’s painful using R and Rscirpt in command line. Since the Documents has been hijacked by OneDrive, whenever you open the directory C:\User\YourName\Documents it automatically redirects to C:\Users\YourName\OneDrive - Spectrum Health\Documents. You don’t want to backup 2-GB R library fold to the OneDrive. How to reach the real C:\User\YourName\Documents instead of C:\Users\YourName\OneDrive - Spectrum Health\Documents, you have to go C: drive, then User folder, then YourName folder, then Documents.

Jun 19, 2018 Database

Add password to root MySQL on Mac (brew)

ERROR! The server quit without updating PID file

A: Try brew services start mysql
Credit to StackOverflow.

Table 'mysql.role_edges' doesn't exist

A: Try mysql_upgrade -u root
Credit to StackOverflow.

Access denied for user 'root'@'localhost' (using password: NO)

A: Try mysql_secure_installation and follow instruction to setup new password.
Credit to StackOverflow.

Jun 5, 2018 Machine Learning

Sparse Matrix and Dummy Variables

Why sparse matrix? XGBoost only works with matrices that contain all numeric variables; consequently, we need to one-hot encode our data. (UC Business Analytics R Programming Guide) caret::preProcess uses bagging regression trees for missing values recovery (Yevhen Vasylenko), which requires all numeric variables. There are different ways to do this in R. library(tidyverse) dd <- data.frame(a = gl(3,4), b = gl(4,1,12), c = 1:12, d = sample(c("X", "Y", "Z"), 12, replace = TRUE)) str(dd) ## 'data.

May 30, 2018 Data Science, Database

Database with R: PostgreSQL

Load library library(tidyverse) library(RPostgres) library(DBI) Connect to PostgreSQL Connect Method 1 with RPostgres con1 <- DBI::dbConnect(RPostgres::Postgres(), dbname = "testdb1", password = rstudioapi::askForPassword("Database password")) dbListTables(con1) #dbWriteTable(con1, "mtcars", mtcars) #dbWriteTable(con1, "flights", nycflights13::flights) rstudioapi::askForPassword requires the password input In the command line (or block-run), there will be popout dialog to input password, In the knit mode, render the RMarkdown file as follows: rmarkdown::render("MyDocument.Rmd", params = "ask") See Parameter User Interfaces In the blogdown, server_site will halt at the above block.

May 10, 2018 Data Science, Time Series

Time Series Analysis II: zoo

zoo: S3 Infrastructure for Regular and Irregular Time Series (Z’s Ordered Observations) An S3 class with methods for totally ordered indexed observations. It is particularly aimed at irregular time series of numeric vectors/matrices and factors. zoo’s key design goals are independence of a particular index/date/time class and consistency with ts and base R by providing methods to extend standard generics Base Time-Series Objects stats::ts Credit: Time Series Analysis in R Part 1: The Time Series Object by DataSciencePlus