How to CONVERT JSON string file to CSV in RStudio
In this video, I show you how to convert a JSON string file to CSV using R and how to deal with new (\n) and return lines (\r) causing your lines of data to show on extra rows, instead of 1 row.
#rstat #dataanalyst #rstudio
📁 JSON file
https://data.world/deanchereden/twitt...
📁 Rscript file
https://data.world/deanchereden/twitt...
▶️ How to download and install R and RStudio
• How to Download R & R Studio, Run R Studio...
🔖c h a p t e r s 🔖
00:00 - Intro
00:20 - Install & load packages
00:45 - Import JSON file
01:26 - Export as CSV (returns not fixed)
02:11 - Understand why you see extra lines
05:27 - Find columns with returned lines
08:38 - Replace \n & \r to stop extra lines
11:00 - Export as CSV with return lines fixed
My RStudio Appearance Setup
RStudio theme: Modern
Zoom: 100%
Editor font: Lucida Console
Text rendering: (Default)
Editor font-size: 16
Editor theme: Tomorrow Night 80s
To learn how to change your appearance in RStudio here: • How to Download R & R Studio, Run R Studio...
Contact and Socials
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
Music
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felicidade)...