How to Create None Value into Python Pandas

Question

        a= []
        for item in soup2.findAll("div", class_='x'):
            where_to_watch = item.find_all('b')
            watch_at.append(x)
            
        dataFrame = pd.DataFrame(data = a)
        dataFrame.to_excel('x.xlsx')
        print(dataFrame)

Hello Guys How can i add "text" when the value is none? or maybe add NAN value...

If where-to_watch is None then it will be added to the List watch_at as None and then will appear in the DataFrame as NaN. So where is the problem? — user19077881
– user19077881, Commented Jan 28, 2023 at 15:07
Fixed it already i just added the new = dataFrame.fillna("NO DATA") fill na method — kotefi9010
– kotefi9010, Commented Jan 28, 2023 at 15:19

Timus · Accepted Answer · 2023-01-28 20:54:33Z

1

I think you could use fillna() method to achieve your goal. It would look like that:

dataFrame = dataFrame.fillna("text")
dataFrame.to_excel('watch.xlsx')

Also there's a function called isna(). You could use it like that:

if pd.isna(where_to_watch):
    where_to_watch = "text"
watch_at.append(where_to_watch)
dataFrame.to_excel('watch.xlsx')

edited Jan 28, 2023 at 20:54

Timus

11.4k5 gold badges20 silver badges33 bronze badges

answered Jan 28, 2023 at 15:33

Mateusz Zdanowski

263 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Create None Value into Python Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related