# Articles by Pascal Schmidt

### The Question That Got Me My First Data Analyst Job

April 14, 2021 |

In this blog post, we will be exploring how I answered a question that got me my first job as a data analyst. It was an open-ended question and was supposed to be answered in a casual/theoretical way. The question was “How would you collect all cities in Qatar ...

### Doing Row-wise Operations the Column-wise Way With tidyr pivot_longer

February 24, 2021 |

Row-wise operation always feel a bit strange and awkward to me. At the same time they are really fascinating as well because we mostly deal with column-wise operations. In this blog post, we will be going through a #tidytuesday data set that is about plastic and we will be doing ... [Read more...]

### Custom Message Handler in R Shiny – Resembling insertUI & removeUI

February 17, 2021 |

In April this year, I will have used R Shiny for a year. I am coming from a statistics background and the first programming language I learned was R and then Python. I am using R Shiny almost every week at work and I am amazed by how powerful it ...

### Persistent Data Storage With a MySQL Database in R Shiny – An Example App

February 9, 2021 |

Last tutorial, we built a Shiny application where the user can add, delete, and edit specific row. Today we want to integrate a remote MySQL database for persistent data storage. When the user changes the anything of the table, the results are send to the MySQL database and will be ...

### Predicting Housing Prices with Natural Language Processing NLP and Tidymodels

February 2, 2021 |

In this tutorial, we will be predicting housing prices based on their descriptions. We will be using natural language processing, NLP, to build a machine learning model. We will be using bag of words with column vectors of ones and zeros. If you want to reproduce the analysis or check ...

### Creating Beautiful and Flexible Summary Statistics Tables in R With gtsummary

January 24, 2021 |

gtsummary is a great package for doing summary statistics tables in R. The package has a lot of functionality and I like the flexibility of the package. Doing summary statistics tables with this package is very easy and I like this package almost as much as the arsenal package. Almost ...