string 'None' and NoneType in python's dataframe

Question

Make a list containing two elements : 'None' and None.

x = ['None',None]
x
['None', None]
print(x)
['None', None]

It is obvious that the first is a string whose value is 'None', the second is a NoneType None in python.

Create a dataframe which contain the two element also:

df = pd.DataFrame({"content": ['None', None]})
type(df.iloc[0,0] )
<class 'str'>
type(df.iloc[1,0])
<class 'NoneType'>
df
  content
0    None
1    None
print(df)
  content
0    None
1    None

Maybe python community should make a progress to display it such as shown the list:

df
  content
0    'None'
1    None
print(df)
  content
0    'None'
1    None

C.K. · Accepted Answer · 2022-02-04 02:58:56Z

1

First of all, in normal cases, there should not be two types of data in one column of a completed DataFrame. Therefore a str and a NoneType cannot show themselves together after data washing.

And in normal cases, we don't want to see so many '' in a string column. It will be annoying. And if you do want to see them, try:

df.content.apply(lambda x: x if not isinstance(x,str) else repr(x))

And the result is what you want:

0    'None' 
1      None  
Name: content, dtype: object

answered Feb 4, 2022 at 2:58

C.K.

1,62214 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

string 'None' and NoneType in python's dataframe

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