文档：DataFrame 数据列整数值累加.note

最新推荐文章于 2024-07-06 03:01:05 发布

weixin_37942177

最新推荐文章于 2024-07-06 03:01:05 发布

阅读量1.6k

点赞数 2

分类专栏： pandas

本文链接：https://blog.csdn.net/weixin_37942177/article/details/109249977

版权

文档：DataFrame 数据列整数值累加.note

想把counts列累加

# -*- coding= utf-8 -*-
import pandas as pd
import numpy as np

partno ='no001'
quantity =1000

df= pd.read_excel('./circleArea.xlsx',
                 sheet_name='Sheet2')

dfp=df.loc[df['partno']==partno]
dfp.loc[:,('counts',)]=dfp.loc[:,('counts',)].astype('float64')
dfp['countscumsum']= dfp['counts'].cumsum()
dfp

有警告但是结果是想要的

<ipython-input-33-06bee3932c21>:13: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = val