In this video, I show you how to convert a JSON string file to CSV using R and how to deal with new (
) and return lines (
) causing your lines of data to show on extra rows, instead of 1 row.
#rstat #dataanalyst #rstudio
📁 JSON file
data.world/dea...
📁 Rscript file
data.world/dea...
▶️ How to download and install R and RStudio
• How to Download R & R ...
🔖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
&
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 ...
Contact and Socials
💌 My email - dean@deanchereden.com
🌍 My website - www.deanchered...
🐦 Twitter - / deanchereden
Music
🎵 Vhsceral - Gimetime chll.to/dd82e17f
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - ...
Негізгі бет How to CONVERT JSON string file to CSV in RStudio
No video
Пікірлер: 4