agate tries very hard to adequately support non-US, non-English users. This means properly handling foreign currencies, date formats, etc. To facilitate this, agate makes a hard distinction between your locale and the locale of the data you are working with. This allows you to work seamlessly with data from other countries.
Set your locale¶
Specifying your current locale works the same as with any other Python module. Please see the
locale documentation for more details. Changes to your locale will automatically change how agate data is printed to the console and serialized to CSV files, but will not effect how data is parsed. See Specify locale of numbers for that.
Specify locale of numbers¶
To correctly parse numbers from non-US locales, you can pass a
locale parameter to the
Number constructor. For example, to parse Dutch numbers (which use a period to separate thousands and a comma to separate fractions):
dutch_numbers = agate.Number(locale='de_DE') column_names = ['city', 'population'] column_types = [text_type, dutch_numbers] table = agate.Table.from_csv('dutch_cities.csv', columns)