There isn’t any great way to do this right now, see github issue here for some discussion. As a quick hack, could do something like this, maintaining a separate dict with the units. In [3]: units = {} In [5]: newcols = [] …: for col in df: …: name, unit = col.split(‘ ‘) …: … Read more
Pass in a custom NumberFormatInfo with a custom NumberGroupSeparator property, and use the #,# format to tell it to do number groups. This example uses the invariant culture’s number format as its basis. var nfi = (NumberFormatInfo)CultureInfo.InvariantCulture.NumberFormat.Clone(); nfi.NumberGroupSeparator = ” “; string formatted = 1234897.11m.ToString(“#,0.00”, nfi); // “1 234 897.11”