read csv file: variable name consists of multiple words: resulting table variable name

4 views (last 30 days)
I readtable a csv file of the format
date new york
---------------------
1/1/2021 15
1/2/2021 20
Then the resulting table has
class_Var1 class_NewYork
----------------------------
datetime double
But I just want to have a variable name 'New York'. Is it possible?

Accepted Answer

Nolan Canegallo
Nolan Canegallo on 24 Jan 2021
Edited: Nolan Canegallo on 24 Jan 2021
If you have R2020b+, then you can use a modifier:
tableName = readtable('filename.csv','VariableNamingRule','preserve')
If you have R2019b+, then you can use the modifier:
tablename = readtable('filename.csv','preservevariablenames',true)
Credit to Walter Roberson for noticing this typo in the documentatation.
  6 Comments
Walter Roberson
Walter Roberson on 24 Jan 2021
Again, you are assuming that the "Starting in R2019b" applies to the whole paragraph, but it does not.
Consider "Starting in 1979, I no longer lived in the house I grew up in. I live in central Canada." Does that mean that I have lived in central Canada all of my life? Does that mean that I have lived in central Canada since 1979? Does the second sentance somehow become incorrect when you know that I have lived in central Canada since the early 1990s, and if so where is the error, since both parts are individually true?

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!