tablesaw icon indicating copy to clipboard operation
tablesaw copied to clipboard

Possibility to read missing values as null

Open andreybavt opened this issue 3 years ago • 1 comments

Hi, I was reading the docs and didn't find if it was possible to read missing values as null instead of empty strings.

For example here's a pandas analogy:

serialized = df.to_csv(index=False, na_rep="NA")

deserialized = pd.read_csv('filename', na_values=["NA"], keep_default_na=False)

andreybavt avatar Aug 26 '22 15:08 andreybavt

missing values are read as empty strings only.

On Fri, Aug 26, 2022 at 11:27 AM Andrey Avtomonov @.***> wrote:

Hi, I was reading the docs and didn't find it ti was possible to read missing values as null instead of empty strings.

For example here's a pandas analogy:

serialized = df.to_csv(index=False, na_rep="NA") deserialized = pd.read_csv('filename', na_values=["NA"], keep_default_na=False)

— Reply to this email directly, view it on GitHub https://github.com/jtablesaw/tablesaw/issues/1141, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2FPAVNVKW5GN3XF56LJY3V3DO6TANCNFSM57XECZFQ . You are receiving this because you are subscribed to this thread.Message ID: @.***>

lwhite1 avatar Aug 26 '22 15:08 lwhite1