Skip to content

feature request: detect if a string column is actually numeric #157

@dustmop

Description

@dustmop

If a column of numerical data is all string values, for example parsed out of a webpage using a scraper, then DataFrame will treat the column as a string type. Instead, it could automatically convert them to numbers. This causes feature drift from the python pandas version, but may be worth doing anyway.

In addition, if a string contains commas, we could suggest that they be automatically stripped before converting to a string. This feature could also take the locale into account, and strip periods instead for those locales that use them for decimal place separation. See https://docs.oracle.com/cd/E19455-01/806-0169/overview-9/index.html for a list of different representations.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions