#1 by Chris_oTree
I have added a new feature called read_csv(). It's useful when you want to define data about your treatments in a CSV file: https://otree.readthedocs.io/en/latest/misc/advanced.html#reading-csv-files
#2 by Daniel_Frey
Hi Chris One small question concerning this feature: when I export an Excel file into a CSV file, the separator is a semi-colon (It depends on the computer's system language), not a comma. I have not yet figured out how to use read_csv() with such a file. I could change the separators in the CSV file itself, but that creates other problems. Can one use read_csv() with a semi-colon-separated file, or could you add an option that one can specify the separator? Best, Daniel
#3 by Chris_oTree
I think in Excel there is a setting to export CSV with dot as decimal separator: https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/#:~:text=To%20save%20Excel%20file%20as,Decimal%20separator%20to%20period%20(.) I’ll look into it but try that for now.
#4 by Daniel_Frey
I tried that already, but unfortunately, that did not work correctly. (It somehow converted numbers like 1.2 to 1. February and similar shenanigans)
#5 by Chris_oTree
Can you send me the original Excel file? firstname.lastname@example.org. I will take a look when I have time.
#6 by Daniel_Frey
Thanks! I just sent it to you. Best, Daniel