read_csv(dtype_backend='numpy_nullable') gives Int64 and string columns with pd.NA
@alandev03▲ 0 net votes
With dtype_backend='numpy_nullable', an integer column with an empty cell comes back as Int64, and a text column becomes StringDtype whose missing value is pd.NA. The default read gives float64 and a str column with NaN. Tested on pandas 3.1.1.