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/databrowser/view/lfsq_egan/default/table?lang=en

Video #2 data cleansing: https://youtu.be/rW9gPsOU4g0

- 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: inforvstats@gmail.com

## Twitter : https://twitter.com/raulvaleriom


Mi canal en español:

https://www.youtube.com/channel/UCe4UCHmQu92O03Z1fgzUXmQ


## Statistics and data science Course in R

https://www.youtube.com/playlist?list=PLgedSm0esItUtAwceJ0jC40GwxvTQRCRK

## Tutorial course in Python

https://www.youtube.com/playlist?list=PLgedSm0esItVLLtlAIGlhGYRDcJvT_NLL

Dictionaries in Python: https://youtu.be/C6Y5GvV8nOU
Range and sequences in Python : https://youtu.be/hmOBfqKaC5g
Tuples, sets and vectors in Python : https://youtu.be/2U8fInYd6lc
Create List: https://youtu.be/m9ln3Y4x6Lk

## More Python videos and machine learning
https://www.youtube.com/playlist?list=PLgedSm0esItUGSL3F6RyO_s7U7mZO5gwl

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