Negative number formatted as integer gives ArrowInvalid

Using Streamlit
1

I have this error:
ArrowInvalid: (“Could not convert ‘-’ with type str: tried to convert to int”, ‘Conversion failed for column XXX with type object’)

I am using sqlite
Yes, the column formatted as integer and have negative number with “-” in front of the number
Please help, thank you

1 Like
2

Hi @ari, and welcome to the Streamlit community! :balloon::raised_hands:

Have you tried to convert the numbers in your column to integers?

Thanks,
Charly

1 Like
3

@Charly_Wargnier Thank you for your reply
Finally i know why
It is because there are records with zero amount but represent as “-”
The problem is gone after i change “-” to zero (“0”)

4

I’m glad you found a solution to this @arri!

Happy Streamlitin’! :balloon::raised_hands:

Best,
Charly