让它成为以下Python Panda数据帧:
NAME NUM_OWNERS NUM_DOCS NUM_RESIDENTS
Total 23900137 21028886 44571130.0
Macael-04062 366607 324413 727945.0
Spain 4283950 3642683 8464411.0
Badalona-08911 5829 6250 15480.0
Vallecas-28031 5691 5215 10358.0
我希望保留包含5位数字的行,并按该数字修改NAME
列的值.
结果数据帧:
NAME NUM_OWNERS NUM_DOCS NUM_RESIDENTS
04062 366607 324413 727945.0
08911 5829 6250 15480.0
28031 5691 5215 10358.0