Pandas DataFrame doesn't handle special values correctly

Description

While testing special values in python client, I found this:

  • None appears as NaN in Pandas DataFrame

  • Pandas DataFrame writes NaN to csv as empty value

  • Pandas DataFrame reads empty value as NaN

  • Pandas DataFrame reads "Infinity" as object instead of float('Inf')

Created this issue to capture findings in: https://sagebionetworks.jira.com/wiki/spaces/PLFM/pages/190644243/Special+values+in+Synapse

Environment

None

Assignee

Unassigned

Reporter

Kimyen Truong

Labels

None

Validator

None

Development Area

None

Release Version History

None

Slack Channel

None

Epic Link

Components

Priority

Minor