iSixSigma

Minitab: Splitting Column Data into Multiple Columns

Six Sigma – iSixSigma 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 2 months, 2 weeks ago.

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

    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

    0
    #203144

    Chuck White
    Participant

    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.

    0
    #203147

    Chris Seider
    Participant

    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

    0
    #203155

    Minitab
    Participant

    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.

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

You must be logged in to reply to this topic.