Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Reading MaxDiff data in CSV for analysis in CBC HB


I have received a MaxDiff data file in csv format with the following columns:

1. Respondent ID
2. Task no.
3. 4 columns corresponding to the 4 attributes shown in a set
4. Best selection
5. Worst selection

I want to convert into a format which is readable by CBC HB for analysis. Any suggestions?

Thank you.

asked Apr 11, 2017 by Ashish04 (120 points)

1 Answer

+1 vote
Hi, Ashish,

I usually do this kind of conversion in Excel,  where it's pretty easy to chop and sort and reassemble the data.  I know other folks who are more comfortable with SAS or R and they might do the manipulations there, but this sounds like a pretty straightforward one that would work well in Excel.
answered Apr 11, 2017 by Keith Chrzan Platinum Sawtooth Software, Inc. (62,700 points)
Thanks, Keith!!!

Would you be kind enough to share the steps for this restructuring or the format in which the data should be.

Ashish, it's just a matter of copying and pasting and sorting and such in Excel.  We can do this data restructuring for you but we would need to charge you for it.  If interested please contact me at keith@sawtoothsoftware.com