Excel Skills for Business by Macquarie University.Introduction to Psychology by Yale University.Business Foundations by University of Pennsylvania.IBM Data Science Professional Certificate by IBM.Python for Everybody by University of Michigan.Google IT Support Professional by Google.The Science of Well-Being by Yale University.AWS Fundamentals by Amazon Web Services.Epidemiology in Public Health Practice by Johns Hopkins University.Google IT Automation with Python by Google.Specialization: Genomic Data Science by Johns Hopkins University.Specialization: Software Development in R by Johns Hopkins University.Specialization: Statistics with R by Duke University.

Specialization: Master Machine Learning Fundamentals by University of Washington.

Courses: Build Skills for a Top Job in any Industry by Coursera.

Specialization: Python for Everybody by University of Michigan.

Specialization: Data Science by Johns Hopkins University.

Course: Machine Learning: Master the Fundamentals by Standford.

My_data <- read_excel('my_file.xlsx', na = '-')Ĭoursera - Online Courses and Specialization Data science If NAs are represented by something (example: “-”) other than blank cells, set the na argument:

Case of missing values: NA (not available).

My_data <- read_excel('my_file.xlsx', sheet = 2) My_data <- read_excel('my_file.xlsx', sheet = 'data') If you use the R code above in RStudio, you will be asked to choose a file.

It’s also possible to choose a file interactively using the function file.choose(), which I recommend if you’re a beginner in R programming:.

To know your current working directory, type the function getwd() in R console.

The above R code, assumes that the file “my_file.xls” and “my_file.xlsx” is in your current working directory. The readxl package comes with the function read_excel() to read xls and xlsx files

Convert excel to mac format