Python Split Object into multiple String using delimiters [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 4 years ago.

Improve this question

I have try many way, but there are error or N/A for those solution, can any people help me split the data? (Error: ValueError: Columns must be same length as key). The Data Type Is object

	prices
1	[Apr 26 2013 01: +0, 13.326, 22]
2	[Apr 27 2013 01: +0, 14.301, 49]

INTO Something like this

	date	price	volumn
1	26/04/2013	13.326	22
2	27/04/2013	14.301	49

Does this answer your question? Pandas Split column into multiple columns by multiple string delimiters — ti7
– ti7, Commented Dec 30, 2020 at 16:45
there is a ValueError: Columns must be same length as key error — user14219875
– user14219875, Commented Dec 30, 2020 at 16:53

k33da_the_bug · Accepted Answer · 2020-12-30 17:37:28Z

0

Assuming you have data in ['date','price','volume'] format, you can extract columns as follows.

import pandas as pd

data = {
    'date_price_volume' : [['Apr 26 2013 01: +0', 13.326, 22],['Apr 27 2013 01: +0', 14.301, 49]]
}

df = pd.DataFrame(data)
df = pd.DataFrame(df['date_price_volume'].to_list(), columns=['date','price','volume'])
df

answered Dec 30, 2020 at 17:37

k33da_the_bug

8208 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python Split Object into multiple String using delimiters [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related