Keiku
/ convert_number_strings_to_numbers.py
Last active
January 8, 2023 20:45
Convert number strings with commas in pandas DataFrame to float.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import pandas as pd | |
| import locale | |
| from locale import atof | |
| df = pd.DataFrame([['1,200', '4,200'], ['7,000', '-0.03'], ['5', '0']], | |
| columns=['col1', 'col2']) | |
| # col1 col2 | |
| # 0 1,200 4,200 | |
| # 1 7,000 -0.03 | |
| # 2 5 0 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "USD": { | |
| "symbol": "$", | |
| "name": "US Dollar", | |
| "symbol_native": "$", | |
| "decimal_digits": 2, | |
| "rounding": 0, | |
| "code": "USD", | |
| "name_plural": "US dollars" | |
| }, |