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

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

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.

I tried that already, but unfortunately, that did not work correctly. (It somehow converted numbers like 1.2 to 1. February and similar shenanigans)

Can you send me the original Excel file? chris@otree.org. I will take a look when I have time.

Thanks!

I just sent it to you.

Best,
Daniel