A pit for pandas to do computing!

problem description

A pit when performing operations in the actual development of pandas!

--------------------------------------------------------------------------------
   age  name
0   10   abc
1   11  None
2    9   def
--------------------------------------------------------------------------------
   age  name
0   10   abc
1   11  None

--------------------------------------------------------------------------------
   age name
0   10  abc

I would like to ask why the results of new1 and new2 are different?

Aug.20,2021

>>> df2 = pd.DataFrame([{'name': 'abc', 'age': 10}, {'name': '', 'age': 11}, {'name': 'def', 'age': 9}])
>>> df2.dtypes
age      int64
name    object
dtype: object
>>> (df2['age'] >= 10)
0     True
1     True
2    False
Name: age, dtype: bool
>>> df2['name'].str.contains(v['value'])
0     True
1    False
2    False
Name: name, dtype: bool
>>> (df2['age'] >= 10) | df2['name'].str.contains(v['value'])
0     True
1     True
2    False
dtype: bool
>>> df2['name'].str.contains(v['value']) | (df2['age'] >= 10)
0     True
1     True
2    False
dtype: bool
>>> 
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-7b30f1-26251.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-7b30f1-26251.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?