Скачать или смотреть 2.1 Read and import xlsx excel file in R / Rstudio | Statistical analysis and data science course

In this chapter of the video series in the crash course in statistics analysis and data science with R / Rstudio we will talk about how to read and import an excel file in R.

Using Click and Point in Rstudio for reading files
What to do when my file has more than one work sheet ?
How to select range of data in xls file in one sheet?
Skipping lines or observations in excel file
File and table Preview
Download and utilise files from the web

Link for downloading excel xlsx file:

https://ec.europa.eu/eurostat/databro...

Video #2 data cleansing:    • 2.2 Cleaning and importing excel files in ...  

Reading excel files with R code as well as other options.
Skipping lines or observations in the file
What to do when my file has more than one work sheet ?
Removing and dropping columns and observations in the Dataframe
Renaming columns and observations with colnames and rownames
Using sequences and functions for data cleaning
Rounding numerical values and decimals
How to treat and convert symbols to Missing values
Dataset Preview


Any comment or suggestion is welcome

Contact: [email protected]

Twitter :   / raulvaleriom  


Mi canal en español:

   / @rvstats_es  


Statistics and data science Course in R

   • R Tutorial | Rstudio  

Tutorial course in Python

   • Python tutorial  

Dictionaries in Python:    • 1.4 Creating dictionaries in Python | keys...  
Range and sequences in Python :    • 1.2 Range and sequences in Python | Numpy ...  
Tuples, sets and vectors in Python :    • 1.1 Data types and objects in Python | tup...  
Create List:    • 1.3 Creating lists in Python | functions |...  

More Python videos and machine learning
   • Python  

Learn python from zero
beginner
Learning
Statistical analysis
Factor, vector, list, jupyter, notebook
input and output
data mining
Machine learning and supervised learning
Statistical data analysis
Linear algebra
mathematic
math
tutorial for starters
python basics
statistics for beginners