import pandas as pd
import numpy as np
"""
本节主要介绍settingwithopywarrning的报警复现,原因,解决方案
"""
path = './test.csv'
df = pd.read_csv(path)
df.loc[:,'bWendu'] = df['bWendu'].astype(str).str.replace('C','').astype('int32')
df.loc[:,'yWendu'] = df['yWendu'].astype(str).str.replace('C','').astype('int32')
tion = df['ymd'].str.startswith('2018-03')
df[tion]['wencha'] = df['bwendu']-df['ywendu']
df['tion'].head()
"""
因为df[tion]['wencha']是一个链式操作,分两个步骤,先get后ser,get得到的dataframe可能是view也可能是copy,pandas才发出警告
所有pandas的dataframe的修改写操作,只允许在源dataframe上进行,一步到位
"""
df.loc[tion,'wenccha'] = df['bwendu']-df['ywendu']
df[tion].head()
df_1 = df[tion].copy()
df_1['wencha'] = df['bwendu']-df['ywendu']
"""
所以dataframe不允许先筛选子dataframe,再进行修改写入
1.可以使用.loc实现一个步骤直接修改源dataframe
2.先复制一个子dataframe,再执行修改
"""