求问版上各位大神,如何设置多级列变量(把price, sales revenue这些大的变量提取出来)要达到如下图所示的结果要怎么做?
| price | sales revenue | . |
| city | max | min | mean | max | min | mean | max | min | mean |
| beijing | | | | | | | | | |
| shanghai | | | | | | | | | |
| tianjin | | | | | | | | | |
| . | | | | | | | | | |
| . | | | | | | | | | |
| . | | | | | | | | | |
目前我只能做到下图结果:
| city | _NAME_ | max | min | mean |
| beijing | beijing_price | | | |
| shanghai | shanghai_price | | | |
| tianjin | tianjin_price | | | |
| . | | | | |
| . | | | | |
| . | | | | |
| city | _NAME_ | max | min | mean |
| beijing | beijing_sales revenue | | | |
| shanghai | shanghai_sales revenue | | | |
| tianjin | tianjin_sales revenue | | | |
| . | | | | |
| . | | | | |
| . | | | | |
跪谢!!