Importing a data basis with non-standard number notation

asked 2020-06-16 11:09:03 -0500

Cyrille gravatar image

updated 2020-06-16 11:10:10 -0500

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 11:54:08 -0500 )edit