How do you format data for line chart

[Przemek]

I’m trying to create a line chart using Streamlit, but I struggle with preparing data for it. It’s a spreadsheet that can be loaded with Pandas. But sadly it is formatted in a non standard way (or rather I should say - standard in Poland ) - floating point is using “,” not “.”.
In general it looks like this:

I’d love to get a chart with the first column (date) as x and a chosen currency (for example 1USD) for Y, so I’d get a nice view how exchange rates changed across time.

Any suggetsions?

[Goyo]

There is much more to a file than meets the eye through an Excel screenshot. I suggest you share a sample file.