Import CSV with Missing Cells
Up one level
Import CSV with Missing Cells
Hi all,
We're trying to import csv files containing multiple timelines (example shown below). It would be REALLY convenient if we could import the whole CSV file into ELAN and be able to specify that a value is missing without that cell entry showing up as an annotation on its respective tier.
Here's an example of what the CSV files look like:
Tier,Annotation,A,B,C
Deviant,Hindi,37.1,41.6,44.6
Deviant,Hindi,62.6,47.6, 53.6
Deviant, Hindi,85.1,53.6,67.1
Deviant, Hindi,NA,64.1,80.6
Deviant, Hindi,NA,77.6,NA
Deviant, Hindi,NA,,86.6,NA
A B and C represent different timelines that obviously have different numbers of events in them.
Can anyone PLEASE help?
Thank you,
Inkhorn (and Psychology Lab Colleagues)
Re: Import CSV with Missing Cells
I'm not quite sure if I understand the situation correctly. Do the values in the A, B and C columns represent (begin) time values? And you want a row to be skipped if there is no time value (NA)? Or you want an extra checkbox or something in the CSV import window to specify which values to ignore?
-Han
Re: Re: Import CSV with Missing Cells
Thanks for your reply. Yes they are begin times. We would like ELAN to be able to skip the rows where there are no available begin times. If there is a value we can use other than NA that will serve this purpose then we will use it.
Inkhorn
Third party update, regular expressions
