I have a dataset with Keys Biz Unit, Rate, Average. Rate and Average are numerical values and I want to pull them from the dataset as a list of ordered pairs without the keys. I've tried various combinations of Flatten, Normal, and Part to achieve this but no success.

This is a portion of the dataset, the name of the dataset is elastTI.

  • 2
    $\begingroup$ How about ds[[All,2;;3]]? If this is not useful, then please load the dataset as an image cannot be used by respondents. $\endgroup$
    – Syed
    May 10, 2022 at 5:04

1 Answer 1


I do not have your dataset, so I will one from docs:

sales = SemanticImport["ExampleData/RetailSales.tsv"]

enter image description here

Numerical columns here are 1 and 3. The way to get the list of ordered pairs:

Normal@Values@sales[All, {1, 3}]

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.