I have data files, given to me by someone else, with the following format:
'col1','col2','col3' 1,2,3 4,5,6
And so on. CSV reads them just fine, and leaves me with a DataFrame that looks like
|Row | 'col1' | 'col2' | 'col3' | _______________________________________ | 1 | 1. | 2. | 3. | | 2 | 4. | 5. | 6. |
and so on. But I can’t access the columns, because the keys want to have a single-quote in them, but a single-quote is an invalid literal in a key name.
julia> data[:col1] ERROR: KeyError: key :col1 not found julia> data[:'col1'] ERROR: syntax: invalid character literal
Escaping the single-quote with a “\” also doesn’t work. What’s the magic incantation here?