Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/pandas-dev/pandas/issues/47713 below:

Fillna limit with axis=1 · Issue #47713 · pandas-dev/pandas · GitHub

• I have checked that this issue has not already been reported.

• I have confirmed this bug exists on the latest version of pandas.

• I have confirmed this bug exists on the main branch of pandas.

import pandas as pd
import numpy as np

df = pd.DataFrame({'col1': ['5', 0, np.NaN, 10, np.NaN],
        'col2': [7, np.NaN, np.NaN, 5, 3],
        'col3': [12, np.NaN, 1, 2, 0],
        'col4': [np.NaN, 1, 1, np.NaN, 18]})

  col1  col2  col3  col4
0    5   7.0  12.0   NaN
1    0   NaN   NaN   1.0
2  NaN   NaN   1.0   1.0
3   10   5.0   2.0   NaN
4  NaN   3.0   0.0  18.0

The following code does not appear to give the correct results. It appears that the axis parameter is ignored.

df.fillna(50,limit=1,axis=1)

   col1  col2  col3  col4
0   5.0   7.0  12.0  50.0
1   0.0  50.0  50.0   1.0
2  50.0   NaN   1.0   1.0
3  10.0   5.0   2.0   NaN
4   NaN   3.0   0.0  18.0

However, if just one value in the df is a string value, it appears to work correctly. I have made the first value in the dataframe a string value.

df = pd.DataFrame({'col1': ['5', 0, np.NaN, 10, np.NaN], 'col2': [7, np.NaN, np.NaN, 5, 3], 'col3': [12, np.NaN, 1, 2, 0], 'col4': [np.NaN, 1, 1, np.NaN, 18]})

using the same code as above, it now appears that the axis parameter is not ignored.

df.fillna(50,limit=1,axis=1)

   col1  col2  col3  col4
0     5   7.0  12.0    50
1   0.0  50.0   NaN   1.0
2  50.0   NaN   1.0   1.0
3  10.0   5.0   2.0  50.0
4  50.0   3.0   0.0  18.0

fillna() should not ignore the axis parameter, and each NaN value should be filled with 50 along axis = 1

1.4.3

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4