pandas: How do I split text in a column into multiple rows?

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I"m working with a large csv file and the next to last column has a string of text that I want to split by a specific delimiter. I was wondering if there is a simple way to do this using pandas or python?

CustNum  CustomerName     ItemQty  Item   Seatblocks                 ItemExt
32363    McCartney, Paul      3     F04    2:218:10:4,6                   60
31316    Lennon, John        25     F01    1:13:36:1,12 1:13:37:1,13     300

I want to split by the space(" ") and then the colon(":") in the Seatblocks column, but each cell would result in a different number of columns. I have a function to rearrange the columns so the Seatblocks column is at the end of the sheet, but I"m not sure what to do from there. I can do it in excel with the built in text-to-columns function and a quick macro, but my dataset has too many records for excel to handle.

Ultimately, I want to take records such John Lennon"s and create multiple lines, with the info from each set of seats on a separate line.

👻 Read also: what is the best laptop for engineering students?

pandas: How do I split text in a column into multiple rows? __del__: Questions

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

from time import sleep
sleep(0.1) # Time in seconds

pandas: How do I split text in a column into multiple rows? __del__: Questions

We hope this article has helped you to resolve the problem. Apart from pandas: How do I split text in a column into multiple rows?, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano pandas: How do I split text in a column into multiple rows?
• Deutsch pandas: How do I split text in a column into multiple rows?
• Français pandas: How do I split text in a column into multiple rows?
• Español pandas: How do I split text in a column into multiple rows?
• Türk pandas: How do I split text in a column into multiple rows?
• Русский pandas: How do I split text in a column into multiple rows?
• Português pandas: How do I split text in a column into multiple rows?
• Polski pandas: How do I split text in a column into multiple rows?
• Nederlandse pandas: How do I split text in a column into multiple rows?
• 中文 pandas: How do I split text in a column into multiple rows?
• 한국어 pandas: How do I split text in a column into multiple rows?
• 日本語 pandas: How do I split text in a column into multiple rows?
• हिन्दी pandas: How do I split text in a column into multiple rows?