read csv file: variable name consists of multiple words: resulting table variable name
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
alpedhuez
le 24 Jan 2021
Commenté : Walter Roberson
le 24 Jan 2021
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?
0 commentaires
Réponse acceptée
Nolan Canegallo
le 24 Jan 2021
Modifié(e) : Nolan Canegallo
le 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 commentaires
Nolan Canegallo
le 24 Jan 2021
Modifié(e) : Nolan Canegallo
le 24 Jan 2021
I agree that it is easy enough to check, however, it does not mention the correct date in the section with the flag. I think including R2019b in this section is misleading, since it implies that this flag is compatible with R2019b.
Walter Roberson
le 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?
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!