Python - Pandas DataFrame incorrectly breaks my table into 2 rows

[kkkttt]

Anyone knows how to deal with this?

Here's my original dataset (2 rows):

id	title
abc 123	t1
abc124	t2

I run below python scripts in Power Query:

# 'dataset' holds the input data for this script
import pandas as pd
data = pd.DataFrame(dataset)

And it breaks my dataset into below tables (3 rows):

id	title
abc	t1
123
abc124	t2

I cannot modify the ['id'] column in the raw datasource, how can I fix this error?

I tried to run the same script in Jupyter notebook, and the code doesn't break the row as it did in Power BI.

Thanks in advance.

[Icey]

Hi @kkkttt ,

I am curious if my reply above could meet your requirements.

If it could, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards,

Icey

[Icey]

Hi @kkkttt ,

Based on your requirements, just try this easier method:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.