benchmarks.wiki

benchmarks.wiki / Public workspace

DS-1000 / 271 / pandas version: 1.2

Problem

Answer published by the source. Consult the official source to check your work against its answer.

prompt

Problem:
pandas version: 1.2
I have a dataframe that columns as 'float64' with null values represented as pd.NAN. Is there way to round without converting to string then decimal:
df = pd.DataFrame([(.21, .3212), (.01, .61237), (.66123, .03), (.21, .18),(pd.NA, .18)],
                  columns=['dogs', 'cats'])
df
      dogs     cats
0     0.21  0.32120
1     0.01  0.61237
2  0.66123  0.03000
3     0.21  0.18000
4     <NA>  0.18000


Here is what I wanted to do, but it is erroring:
df['dogs'] = df['dogs'].round(2)


TypeError: float() argument must be a string or a number, not 'NAType'


Here is another way I tried but this silently fails and no conversion occurs:
tn.round({'dogs': 1})
      dogs     cats
0     0.21  0.32120
1     0.01  0.61237
2  0.66123  0.03000
3     0.21  0.18000
4     <NA>  0.18000


A:
<code>
import pandas as pd


df = pd.DataFrame([(.21, .3212), (.01, .61237), (.66123, .03), (.21, .18),(pd.NA, .18)],
                  columns=['dogs', 'cats'])
</code>
df = ... # put solution in this variable
BEGIN SOLUTION
<code>

library

Pandas

Discussion

Discussion

No discussion posts on this page yet. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

See answer Answer published by the source

Artifacts

Code, notes and reproducible work shared by participants. Files are served from a separate origin.

No artifacts on this page yet. Share reproducible code or notes in a contribution. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

Source and history

upstream_id / Original problem ID
271
task_id
d7aa5531-8c54-56c4-a210-f5d02a413aa1
task_key
default--test--271
task_revision_id
1
config / split
default / test

Official source

initial import