如何将Excel表格里的数据转化为Dataset结构化数据集？

Question

例如我有如下的Excel表格数据

如何将这个Excel文件转换为Dataset结构化数据集

下面是将这些数据手动生成结构化数据集的Mathematica代码

dataset = Dataset[{
   <|"a" -> <|"x" -> "ax", "y" -> "ay", "z" -> "az"|>, 
    "b" -> <|"x" -> "bx", "y" -> "by", "z" -> "bz"|>, 
    "c" -> <|"x" -> "cx", "y" -> "cy", "z" -> "cz"|>, 
    "d" -> <|"x" -> "dx", "y" -> "dy", "z" -> "dz"|>, 
    "e" -> <|"x" -> "ex", "y" -> "ey", "z" -> "ez"|>, 
    "f" -> <|"x" -> "fx", "y" -> "fy", "z" -> "fz"|>, 
    "g" -> <|"x" -> "gx", "y" -> "gy", "z" -> "gz"|>|>}]

 

Answer 1

这个貌似没有现成的内置函数，得自己写一下。

参考下面代码：

data = Import[SystemDialogInput["FileOpen", ".xlsx"], {"Data", 1}];
row1 = data[[1, 2 ;;]];
col1 = data[[2 ;;, 1]];
tempData = 
  Inner[#1 -> #2 &, row1, Transpose[data[[2 ;;, 2 ;;]]], Association];
yourData = Dataset[{Inner[#1 -> #2 &, col1, tempData, Association]}]

 

Comments

SemanticImport可以，但是调整细节挺麻烦的。

---

都没用到过这么神奇的函数