- Minitab Cookbook
- Isaac Newton
- 359字
- 2021-07-16 12:29:19
Transposing the columns of a worksheet
Data is often structured with categories denoted in a row and multiple observations of these dimensions in subsequent columns. This can be a popular format used in Excel worksheets. Here, we will transpose this into the column format that is preferred by Minitab in the following manner:
In the preceding screenshot, we can see that different individuals are listed starting from the second column. Their resting pulse is in first row, and after activity in second row, it is preferable for this data to be transposed.
Getting ready
The data used in this example is in the Pulse workbook.xlx file. To get this data into Minitab, follow the Opening an Excel file in Minitab recipe.
How to do it…
The following instructions will transpose the numeric columns of the Pulse workbook file:
- Click on the Data menu and then click on Transpose Columns.
- Select the subject columns in the left-hand column panel by selecting C2 and dragging down through the columns till the end of the column list. Then click on Select.
- In the Create variable names using column section, enter
C1and click on OK.
How it works…
Columns of different data types cannot be transposed with this command. We cannot transpose column 1 from the original data into the numeric data held by the subject columns. Row one of the original worksheet becomes column one of the transposed worksheet. Mixing data types will generate an error. Instead, variable names should be optionally identified by the row categories if they are given in a column of the original worksheet. Here, we use column one to identify the column names of the transposed data.
See also
- The Opening an Excel file in Minitab recipe
- The Stacking several columns together recipe
- The Stacking blocks of columns at the same time recipes
- 資本的眼睛
- 新形勢下中國投入產(chǎn)出核算的變革與實踐
- 中國特色社會主義國家審計制度研究
- Citrix? XenMobile? Mobile Device Management
- Big Data Visualization
- 大數(shù)據(jù)搜索與挖掘及可視化管理方案 ：Elastic Stack 5：Elasticsearch、Logstash、Kibana、X-Pack、Beats （第3版）
- 行政單位經(jīng)濟責任審計實務指南
- 下一場全球金融危機的到來：明斯基與金融不穩(wěn)定
- Oracle Primavera Contract Management，Business Intelligence Publisher Edition v14
- 統(tǒng)計學理論前沿（谷臻小簡·AI導讀版）
- Amazon EC2 Cookbook
- 審計學理論與實務
- 圖解經(jīng)濟博弈論（圖解經(jīng)濟學叢書）
- Oracle Enterprise Manager 12c Administration Cookbook
- 中國重點經(jīng)濟領(lǐng)域統(tǒng)計分析