Pandas Dataframe: Different number seperation

Q&A Non-DQ Courses
#1

Hi DQ Team,

I have a Dataframe and I try to get all the numbers straight.
So even if I insert the different datasets the same way and merge them, python changes the 1000er seperators. For me it looks randomly - but I guess - python doesnt do that :smiley:

Number seperation
Number seperation1533×814 59.9 KB

Here the lsat code:
df_ges_new_v5 = pd.read_csv(r’C:\Users\Andreas\data_quest\Datasets\Country Information\finalesets\Dataframe_Renewable_Energy_World_v3.csv’, sep=";")

Can I include here something that helps?

Best
Andreas

#2

especially in the column land are [sq.]… you can see that there is different display modes.