Skip to main content
Mathematica

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • 1
    $\begingroup$ Have you looked at Dataset and AssociationThread in the documentation. Can you post the code you've tried thus far. $\endgroup$ Commented Nov 29, 2015 at 12:50
  • $\begingroup$ Also, it would help if you posted a bit of example data instead of an image. Either make an Excel file with some representative example data (i.e. have unique row labels) and post the results of the import. $\endgroup$ Commented Nov 29, 2015 at 14:35
  • $\begingroup$ data1 = Drop[ Join@Import[ "C:\\Users\\Andrea\\Desktop\\three_region_60_sector_iot.xls", \ {"Sheets", "iot"}], {1, 2}, {1, 2}] // TableForm (whit this command i've imported the data without the headings) , the i've used alfa = Import[ "C:\\Users\\Andrea\\Desktop\\three_region_60_sector_iot.xls", \ {"Sheets", "iot"}] and then headers = Join@Take[alfa, {3, 180}, {1, 2}] (so i've taken the headings )....in the end i've tried io = Association@Thread[Rule[headers, data1]]....but in this case ii doesn't work as i would $\endgroup$ Commented Nov 29, 2015 at 14:58
  • $\begingroup$ Edit the question and post the output from alfa[[ 1 ;; 10 , 1 ;; 10 ]]. This will give a starting point for people so that they don't have to create a dataset to work on. If the data is sensitive then make up a dummy set of data in Excel, import it and post the result. $\endgroup$ Commented Nov 29, 2015 at 15:33
  • $\begingroup$ sorry...i'm having problems about posting what i need because i'm not an expert user $\endgroup$ Commented Nov 29, 2015 at 16:27