Importing a data basis with non-standard number notation

asked 2020-06-16 18:09:03 +0200

Cyrille gravatar image

updated 2020-06-16 18:10:10 +0200

I know this is more a specific Python question but as I use Pandas to read xlsx's basis, I imagine to be able to ask it there.

I want to import a .xlsx data basis. Its very easy with Pandas. But, unfortunately the format number is a french one. Is there a way to tell Pandas to make the conversion automatically.

In StackOwerflow there is this answer "Convert commas decimal separators to dots within a Dataframe" but it's not the same mecanism(csv one)

edit retag flag offensive close merge delete

Comments

I have the feeling that Pandas does the job alone. But I am not sure.

Cyrille gravatar imageCyrille ( 2020-06-16 18:54:08 +0200 )edit