When solving a statistical problem, I get a CSV table with approximately the following data:
expr Therapy 100 A 98 B 87 C 97 D 102 C 96 B 92 D 88 A
I transform it into a dataframe, so that from there I can draw graphics through matplotlib. But before that, I need to calculate statistics for the four samples (A, B, C, D). Is it possible to transform the original table structure in pandas and get it?
ABCD 100 98 87 97 88 96 102 92
Or is it easier to first read the csv into a variable, make a dictionary, count all the indicators in it (median, intragroup square, etc.), and then send everything to the dataframe?