Hello everyone,
I'm relatively new to PD, tough I've worked a lot with MAX MSP in the past (quite far now) doing some generative music with objects (arduino and so on). Needless to say, It's been too long since I opened a patch, so right now It's quite hard to know all that is possible and not be able to do it...
Currently I'm trying to help a colleague who would like the present some data that we've extracted from users of the products that we develop. It may be a very simple sonification or visualization.
I thought it would be quite simpl,e, but honestly I'm struggling to find out just how to extract the data in the columns of our .csv into pd.
So far I've managed to use qlist and textfiles and to load the content, but the textfile window and the console really don't help me since I can't use this data and make a list or any other action.
I've made a good amount of research in the forum, but so far the only examples that I've been able to find are quite complex and it doesn't really help at this stage.
So, if anyone has a VERY simple patch (I'm afraid that even the most basic explanation at this point is confusing to me;I just found out how to copy a patch from text, so you can imagine that my skills are far beyond my intentions ) in order to help me find out how to get the data from my csv (i converted it into a .txt file with ; ) in the ACTUAL patch, either into a message, a symbol, or any other thing that I can start to work with.

Thanks to all for your kind help.
Best,
Melissa

@lavirgenmarea I'd bet that if you were to post a small csv file together with examples of the kinds of Pd messages you'd like to extract from it that someone in this forum would write a beautifully clear example for you (maybe even me if it weren't for the out-of-town wedding I have to attend). I also think that it's probably easier to do the data manipulation and transposition in the spreadsheet software before importing it into Pd.

@lavirgenmarea If the data are arranged as:

number number number number number;
number number number number number;
number number number number number;
number number number number number;
number number number number number;

... (space-delimited, with semicolons) then [text] can turn these into lists.

As a test, I wrote out a text file from SuperCollider like this:

(
f = File("~/matrix.txt".standardizePath, "w");
if(f.isOpen) {
    protect {
        5.do {
            5.do { |i|
                if(i > 0) { f << " " };
                f << 1.0.rand;
            };
            f << ";" << 10.asAscii;
        }
    } { f.close };
} { "huh?".postln };
)

([text] chokes on \n newlines -- ascii code 10 for newline is OK -- first try, \n didn't work, but now it does. Weird.)[text] chokes on \n newlines

Then:

hjh

PS FWIW, SuperCollider has CSVFileReader("/path/to/my.csv").collect { |row| row.collect { |string| string.asFloat } }

Hello again !
Thanks @ddw_music, I can now print the lines.. thanks!
I still can't figure out how to get the data INTO the patch. I'm afraid I'll have to leave Supercollider out of my spectrum for a while ...
So as @jameslo kindly suggested, here you'll find a sample of what my csv will look like.
I'm willing to edit my csv (take the text away) or treat each column separately (I think this will be better in the end). But I still don't know how to bring it back to my patch. I would be interested in knowing how to do it both with numbers (f) or words (s),
Sorry for the basic question, but all the info I find brings me back to the "print" and I'm stuck.
Thanks for your help !!
And enjoy the wedding ! ExpérienceTest.csv

@lavirgenmarea The [text] objects are probably what you want to use but you will want to replace your semicolons with spaces, with the semi colons each cell would be its own line. Here are a few things to get you started, shows how to read the file into [text] and how to get a column as a list or get the floats or symbols from a list. The help files for [text] should provide the rest of your answers and how to do things like get a single cell. Just edit the message box so path/to/expériencetest.csv is the actual path to the file and then click it to read it into the [text] object.
csv.pd

Edit: and make sure to set the column number in the number box or you will just get the entire file.

@oid Thanks a lot ! This patch is super helpful, it really shows me how to do both "techniques" and to start from there.
I only need to figure out how to get this numbers into the working patch (into an object? message? symbol?) and not just in the print console.
Any hints on how to do this will be very useful.
Thanks for your help!

@lavirgenmarea Like this.

Identifiant Groupe Valence-1 Arousal-1 Motivation-1 Taux\ d'erreur_Stroop Taux\ d'erreur_quiz Valence-2 Arousal-2 Motivation-2;
1 1 7 6 23 0 0.4 7 7 21;
2 1 7 1 25 0.0833333333333334 0 8 1 36;
3 2 8 3 28 0 0.2 7 5 27;
4 2 5 2 28 0 0.4 5 3 21;
5 1 6 3 20 0.0833333333333334 0.2 5 4 21;
6 2 7 4 19 0.25 0 6 4 18;
7 1 6 4 24 0 0.2 5 3 23;
8 2 6 5 19 0.0833333333333334 0 6 5 19;
9 NA NA NA NA NA NA NA NA NA;
10 NA NA NA NA NA NA NA NA NA;

Find/replace manual editing in a text editor. (One trick is: backslashes before spaces within cells.)

hjh

@lavirgenmarea said:

I only need to figure out how to get this numbers into the working patch (into an object? message? symbol?) and not just in the print console.

And... here, you encounter a bit of a blind spot... the software is called Pure Data but it takes a long, long time to figure out how to work with... well... data.

In any case, out of the [text get] object, you get lists of numbers, which you can use in the same way that you would use any other list of numbers.

For example, if you wanted to loop over each row and map each number onto a frequency, it might look like this. I'm not sure this is a particularly meaningful mapping, but I went this way to flatten out the few values that are much higher than the others.

hjh

@ddw_music That's perfect
Indeed, à steep learning curve hehe... But it's much better than the first time. Thanks for your kind help.