A column of my csv file is a lis tof tags, separated by a comma, eg:
“tag1, tag2, my third tag with spaces, tag 4”.
I loaded the csv file with string as the type of that column. However, to manipulate the data, I will need to split that string and get a list of tags so I can filter the rows according to their tags.
What is the best approach here?
The type of the column is string, but after the split it will be a list of strings…
Here is the type definition I use for the csv:
type Expenses = CsvProvider<"/notebooks/expenses.csv",HasHeaders=false, Schema="date(string),category(string),amount(float),currency(string),note(string),tags(string)", Culture="DE">
Do I need to define another type? How do I best handle the conversion from string to list of string, and which types do I need to define and use? Or is there a way to pass a column transformation to CsvProvider?