- Minitab Cookbook
- Isaac Newton
- 231字
- 2021-07-16 12:29:19
Extracting values from a date/time column
Often, it can be useful to find values such as day, month, or hour of the day from a date column. This can help later on while trying to find out about the variation in our results, finding effects based on day of the week or month of the year.
Getting ready
The data column displayed in the following screenshot shows dates in the mm/dd/yyyy format. To run this recipe, type the following data into a new column and label the column as Date. We will then create a new column displaying the months from the dates.
How to do it…
The following steps will create a column for the month from the dates in the worksheet:
- Navigate to Data | Extract from Date/Time | Extract to Text.
- In the dialog box, enter the date column in the Extract from date/time column section. Enter
Monthinto the Store text column in section. - Tick the Month selection and click on OK.
How it works…
If the worksheet does not contain a column called Month already, it will create a new column for us. The selected fields will then populate this column in the worksheet. The Extract to Text option will create months and days of the week by their names, where the Extract from date/time to Numeric option will create a column of numbers.
- 中國國民經濟核算體系修訂問題研究
- 一本書學內部審計：新手內部審計從入門到精通
- 注冊會計師全國統一考試專用教材：審計
- 項目管理（第二版）
- Learning Informatica PowerCenter 9.x
- Business Intelligence with MicroStrategy Cookbook
- Microsoft System Center Data Protection Manager 2012 SP1
- 非線性經濟關系的建模
- OAuth 2.0 Identity and Access Management Patterns
- 新編統計學
- vSphere Design Best Practices
- 成功通過PMP（第3版）
- IBM SPSS Modeler Cookbook
- 項目管理實務（第二版）
- PMP備考寶典：路晨帶你去通關