Importing a data basis with non-standard number notation

asked 4 years ago

Cyrille gravatar image

updated 4 years ago

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)

Preview: (hide)

Comments

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

Cyrille gravatar imageCyrille ( 4 years ago )