Skip to main content

list manipulation - Turning table into association for Classify


I have the following sample data for 20 users. I know their sex, and the response for three yes/no questions. I am trying to building a classifier to guess their response to the third question, based on their sex, and the response to the first two questions. It is probably obvious but this is all made up data.


Here is the data:


{{{"M", "Y", "N"} -> "Y"}, {{"F", "Y", "N"} -> 
"N"}, {{"F", "N", "Y"} -> "Y"}, {{"M", "Y", "Y"} ->
"Y"}, {{"M", "Y", "Y"} -> "Y"}, {{"M", "N", "Y"} ->

"Y"}, {{"M", "Y", "Y"} -> "Y"}, {{"M", "N", "Y"} ->
"Y"}, {{"M", "Y", "N"} -> "Y"}, {{"F", "Y", "Y"} ->
"N"}, {{"F", "Y", "Y"} -> "N"}, {{"M", "Y", "N"} ->
"Y"}, {{"F", "Y", "N"} -> "N"}, {{"F", "Y", "N"} ->
"N"}, {{"M", "Y", "N"} -> "Y"}, {{"M", "Y", "N"} ->
"Y"}, {{"M", "Y", "Y"} -> "Y"}, {{"F", "Y", "Y"} ->
"N"}, {{"F", "N", "Y"} -> "N"}}

Then I make a training set from the first 10 elements of the data.


training = data[[1 ;; 10]]


and finally I try to use Classify using built in defaults


cf = Classify[training]

Which gives:


Argument {{{M,Y,N}->Y},{{F,Y,N}->N},{{F,N,Y}->Y},<<4>>,{{M,N,Y}->Y},{{M,Y,N}->Y},{{F,Y,Y}->N}} should be a rule, a list of rules, or an association. >>

I went through Iris data as practice, but since they uses built-in dataset, I'm not sure how the Associations were build behind the scenes.


I would like to understand:


1) How to convert my table, into associations? \ 2) In general, for Classifying is it better to use Mathematica's new Dataset structure?



This question does seems related to : Transform Dataset so it can be used as training set for Classify



Answer



You must change your list structure. right now it is in the form of a list of lists of associations. If you remove the lists, you will have a list of associations, which the classifier function can work with.


cf = Classify[Flatten[training,1]]

I would look at the documentation for AssociationMap and AssociationThread, for good examples of how to build associations.


Comments

Popular posts from this blog

plotting - How to draw lines between specified dots on ListPlot?

I would like to create a plot where I have unconnected dots and some connected. So far, I have figured out how to draw the dots. My code is the following: ListPlot[{{1, 1}, {2, 2}, {3, 3}, {4, 4}, {1, 4}, {2, 5}, {3, 6}, {4, 7}, {1, 7}, {2, 8}, {3, 9}, {4, 10}, {1, 10}, {2, 11}, {3, 12}, {4,13}, {2.5, 7}}, Ticks -> {{1, 2, 3, 4}, None}, AxesStyle -> Thin, TicksStyle -> Directive[Black, Bold, 12], Mesh -> Full] I have thought using ListLinePlot command, but I don't know how to specify to the command to draw only selected lines between the dots. Do have any suggestions/hints on how to do that? Thank you. Answer One possibility would be to use Epilog with Line : ListPlot[ {{1, 1}, {2, 2}, {3, 3}, {4, 4}, {1, 4}, {2, 5}, {3, 6}, {4, 7}, {1, 7}, {2, 8}, {3, 9}, {4, 10}, {1, 10}, {2, 11}, {3, 12}, {4, 13}, {2.5, 7}}, Ticks -> {{1, 2, 3, 4}, None}, AxesStyle -> Thin, TicksStyle -> Directive[Black, Bold, 12], Mesh -> Full, Epilog -> { Line[ ...

list manipulation - Selecting multiple columns from a matrix?

Sample data: data = { {{2013, 1, 1}, 24.13, 167.67, 231.82}, {{2013, 1, 2}, 32.15, 170.92, 225.99}, {{2013, 1, 3}, 35.43, 172.68, 221.67}, {{2013, 1, 4}, 36.73, 173.05, 218.32}, {{2013, 1, 5}, 58.19, 165.96, 197.05}, {{2013, 1, 6}, 69.99, 163.50, 187.52}, {{2013, 1, 7}, 71.37, 154.21, 175.58}, {{2013, 1, 8}, 72.51, 149.66, 163.25}}; I want a DateListPlot with three graphs, so for a matrix formed by columns 1 and 2, one for columns 1 and 3, and 1 for columns 1 and 4. At the moment I'm using this code: data2 = Transpose[{data[[All, 1]], data[[All, 2]]}]; data3 = Transpose[{data[[All, 1]], data[[All, 3]]}]; data4 = Transpose[{data[[All, 1]], data[[All, 4]]}]; DateListPlot[{data2, data3, data4}, Joined -> True, Filling -> {3 -> {1}}] but I have a hunch that this can be done more efficiently. I don't like the Transpose s in particular. Any ideas? edit (for extra credit) What if I need to multiply the second column by 2, which in my solution is simp...

plotting - How to draw some 2D curves in a 3D plot?

I want to plot several 2D curves ( Sin[x] at y=0 , Cos[x] at y=1 ) in a 3D plot, what function should i use? f[x_, y_] := Piecewise[{{0, y 0}, {Sin[x], y == 0}}] g[x_, y_] := Piecewise[{{0, y 1}, {Cos[x], y == 1}}] Plot3D[{f[x, y], g[x, y]}, {x, 0, 10}, {y, 0, 10}] doesn't work. Any ideas? Answer ParametricPlot3D[{{Sin[u], 0, u}, {Cos[u], 1, u}}, {u, 0, 20}, BoxRatios -> 1, PlotRange -> {{-2, 2}, {-.5, 2}, {0, 20}}] === update - general thoughts === I've seen the comments to this question and a few other approaches to the waterfall (or wire) plot are given in this question: Plotting several functions . Also I cannot not mention one of my favorite Mathematica blogs - Archery with this post on the story of discovery of 1st pulsar and an its infamous graphics - code is given in the post: