Column names

The column names are all over the place. We can provide column names that follow a consistent format; we recommend snake_case using the col_names argument.

read_excel(
  "data/students.xlsx",
  col_names = c("student_id", "full_name", "favourite_food", "meal_plan", "age")
)

## # A tibble: 7 × 5
##   student_id full_name        favourite_food     meal_plan           age  
##   <chr>      <chr>            <chr>              <chr>               <chr>
## 1 Student ID Full Name        favourite.food     mealPlan            AGE  
## 2 1          Sunil Huffmann   Strawberry yoghurt Lunch only          4    
## 3 2          Barclay Lynn     French fries       Lunch only          5    
## 4 3          Jayendra Lyne    N/A                Breakfast and lunch 7    
## 5 4          Leon Rossini     Anchovies          Lunch only          <NA> 
## 6 5          Chidiegwu Dunkel Pizza              Breakfast and lunch five 
## 7 6          Güvenç Attila    Ice cream          Lunch only          6