Data wrangling is a task of great importance in data analysis. Data wrangling, is the process of importing, cleaning and transforming raw data into actionable information for analysis. It is a time-consuming process which is estimated to take about 60-80% of analyst’s time. In this series we will go through this process. It will be a brief series with goal to craft the reader’s skills on the data wrangling task. This is the first part of this series and it aims to cover the importing and exporting of data locally.
Please download the data from here
Before proceeding, it might be helpful to look over the help pages for the
Moreover please load the following libraries.
Answers to the exercises are available here.
If you obtained a different (correct) answer than those listed on the solutions page, please feel free to post your answer as a comment on that page.
data.csv file to the
data.txt file to the
data.xls file to the
data.xlsx file to the
- import data into R in several ways while also beeing able to identify a suitable import tool
- use SQL code within R
- And much more
data.json file to the
data.xml file to the
csv_file as “data.csv” and
txt_file as “data.txt”.
xls_file as “data.xls” and
xlsx_file as “data.xlsx”.
json_file as “data.json”.
xml_file as “data.xml”.