0
$\begingroup$

Using the following code generates a view of exactly what I was seeking, 'manipulating' a large spreadsheet/table:

dataset = Dataset[SemanticImport["C:/Downloads/_22702_6.xlsx"]];

Manipulate[Select[dataset,

#"rr_Count"                          > c01        &&
#"rr_Slope_5050x_3"                  > c02        &&
#"rr_Slope_5050x_5"                  > c03        &&
#"rr_Sen_Slope_5050x_5"              > c04        &&
#"rr__50503"                         > c05        &&
#"rr__50505"                         > c06        &],

{{c01, 10, "Count of Occurrences"    }, 1, 100, 1},
{{c02, 80, "Slope_5050x_3"           }, 1, 100, 1},
{{c03, 80, "Slope_5050x_5"           }, 1, 100, 1},
{{c04, 80, "Sen_Slope_5050x_5"       }, 1, 100, 1},
{{c05, 80, "50503"                   }, 1, 100, 1},
{{c06, 80, "50505"                   }, 1, 100, 1}]

After finally getting it to work (thanks @Kuba)..., I'm finding no way to save the results, in a usable format, such as Excel, etc. Best offered is, seems, Enhanced Metafile graphic form.

Yikes!!

Is there concurrence on here that no way exists to capture/save, to then use further??

And, a follow-up question, please. How can I show in the output more than the 20 lines (default). I think I read somewhere that showing more lines is possible. I'd prefer to show ALL lines matching the criteria.

Insights greatly appreciated.

Nicholas Kormanik

"Manipulate, Select, Dataset.png"

Improve this question
$\endgroup$
4
  • $\begingroup$ you can add var = Select[.... and then export var however you like. About additional question: 61030. Is that enough? $\endgroup$
    – Kuba ♦
    Feb 28, 2017 at 6:47
  • $\begingroup$ p.s. one can find 3 questions here. Please stress the main one out and try to not ask many questions at once. (secondary/additional are usually tolerated unless they influence whose answer you accept etc.) $\endgroup$
    – Kuba ♦
    Feb 28, 2017 at 7:57
  • $\begingroup$ Well, @Kuba, seems too complicated to decipher. Plus they appear to be referring to earlier versions of Mma. What I note, though, is that others are complaining about this same thing, wanting a non-truncated dataset view. Sheeesh. Please explain the best solution at present, if you feel like it. $\endgroup$
    – nkormanik
    Mar 2, 2017 at 3:53
  • $\begingroup$ Okay, @Kuba, I got it. Thanks a million for the lead. So, prior to evaluating the Manipulate cell, evaluate the following: Dataset`$DatasetTargetRowCount = 100; to show 100 rows of the dataset. Phew.... $\endgroup$
    – nkormanik
    Mar 2, 2017 at 6:06

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.