MONDAY, NOVEMBER 12, 2018
Font Size
Topic Minitab: Splitting Column Data into Multiple Columns

Minitab: Splitting Column Data into Multiple Columns

Home Forums General Forums Tools & Templates Minitab: Splitting Column Data into Multiple Columns

This topic contains 3 replies, has 4 voices, and was last updated by  Minitab 1 week, 4 days ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #707363

    TV

    Greetings everyone,

    To start with, I’m quite new to the Minitab community, so please excuse me if my questions make no sense.

    My team and I are trying to work with data sets containing up to 2,7 million rows of data. Each row contains the following data: measurement point, date and time and value. The problem is, all this information is in a SINGLE CELL (e.g.: discharge 01.01.2016 01:00:00 35.3300). I could fairly easily separate the data into multiple columns in Excel, but Excel doesn’t cope with such a huge number of rows. Is there a way to do it in Minitab?

    Also, how would you recommend splitting the data afterwards in Minitab? I was thinking max 1 million rows per subset, so the data can be handled by Excel.

    Looking forward to some good discussion!

    Best regards,
    Topi

    #707371

    Once the data is in Minitab, splitting it out into columns will be very difficult — Minitab does not have a text to columns feature like Excel. However, if you are importing the data from a text file, you can specify the field delimiter when you import. The default delimiter is a Tab, but in your example it looks like selecting a Space delimiter will give you what you want.

    #707376

    Check this out. Also, if you have a current Minitab license they can help you with their excellent help line.
    https://blog.minitab.com/blog/understanding-statistics/three-ways-to-get-more-out-of-your-text-data

    #707393

    Hello Topi, and welcome to the Minitab community!

    We wanted to add here that Minitab only offers to split a text string by spaces when you Paste data into a column. If the pasted data contain spaces, you’ll see this dialog box, which does what you’re asking. Choose the first option. (Note there’s no other way to access this dialog box except by pasting data into a column)

    Minitab only offers to split a text string by spaces, when you Paste data into a column. If the pasted data contain spaces, you’ll see this dialog box, which does what you’re asking.

    If the data are already in Minitab, just highlight the entire column and press CTRL+X to cut. Then open Microsoft Notepad and do CTRL+V to paste. Then cut and paste in reverse, back into Minitab and you should see the dialog box above, which will split your values as desired.

    Note, when pasting back into Minitab, click the cursor in Row 1 of the destination column IF the pasted content lacks a column name. If the pasted content does include a column name, then click the cursor above Row 1 of the destination column, immediately before pasting back into Minitab.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.



5S and Lean eBooks

Six Sigma Online Certification: White, Yellow, Green and Black Belt

Six Sigma Statistical and Graphical Analysis with SigmaXL
Six Sigma Online Certification: White, Yellow, Green and Black Belt
Lean and Six Sigma Project Examples
GAGEpack for Quality Assurance
Find the Perfect Six Sigma Job

Login Form