对于我拥有的数据,如下所示(示例):
import pandas as pd
MyDict = {'text' : ['\nbla bla text \n\n bla bla another text \n # bla text \n\n\n bla bla another text',
'\nbla bla bla text2 \n\n\ bla bla bla another text it is \n\n # bla bla bla text \n bla bla it is another text']}
df = pd.DataFrame(MyDict)
我想计算列text
中每个单元格中不为空("\n")的行总数,以便能够获得如下所示的数据帧:
text total_lines
'bla bla text \n\n bla bla another text \n # bla text \n\n\n...' 4
'bla bla bla text2 \n\n\ bla bla bla another text it is \n\n...' 4
第text
列第1单元格中有4条非空行,第2单元格中有4条非空行,依此类推...
我试图搜索stackoverflow,但找不到任何相关建议.有人能帮我一下吗?