pandas重写Q3

最新推荐文章于 2024-09-15 10:39:33 发布

wangquannuaa

最新推荐文章于 2024-09-15 10:39:33 发布

阅读量608

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/wangquannuaa/article/details/46764333

版权

python 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

## -*- coding: utf-8 -*-
import numpy as np
import pandas as pd 
from numpy.matlib import repmat

filepathofU = r'C:\Users\Administrator\Desktop\weixiang.txt'
filepathofV = r'C:\Users\Administrator\Desktop\jingxiang.txt'
#注意index_col = 0的作用是把col:0作为index，否则没有此项会有两列index
df=pd.read_csv(filepathofU,index_col = 0).replace(9999,np.nan).T
#df=pd.read_csv(filepathofV,index_col = 0).replace(9999,np.nan).T

#print df
def calraodong(df,number,start):
    #注意mean(1)为水平方向求均值，mean(0)为垂直方向求均值
    aver = df.iloc[:,start+1:start+number+1].mean(1)
    #注意每列减均值先把列转置成行，然后直接减均值，最后再转置回列
    rao  = df.iloc[:,start+1:start+number+1].T - aver
    raodong = rao.T
    return raodong

Raodong1 = calraodong(df,12,0)
Raodong2 = calraodong(df,12,12)
Raodong3 = calraodong(df,12,24)
Raodong4 = calraodong(df,12,36)
Raodong5 = calraodong(df,12,48)
Raodong6 = calraodong(df,12,60)
Raodong7 = calraodong(df,12,72)
Raodong8 = calraodong(df,1,84)
Raodong9 = calraodong(df,11,85)
Raodong10 = calraodong(df,12,96)
Raodong11 = calraodong(df,12,108)
Raodong12 = calraodong(df,12,120)
Raodong13 = calraodong(df,12,132)
Raodong14 = calraodong(df,12,144)
Raodong15 = calraodong(df,12,156)
Raodong16 = calraodong(df,12,168)
Raodong17 = calraodong(df,12,180)
Raodong18 = calraodong(df,12,192)
Raodong19 = calraodong(df,12,204)
Raodong20 = calraodong(df,12,216)
Raodong21 = calraodong(df,12,228)
Raodong22 = calraodong(df,12,240)
Raodong23 = calraodong(df,12,252)
Raodong24 = calraodong(df,12,264)
Raodong25 = calraodong(df,12,276)
Raodong26 = calraodong(df,11,288)
Raodong27 = calraodong(df,12,299)
Raodong28 = calraodong(df,12,311)
Raodong29 = calraodong(df,12,323)
Raodong30 = calraodong(df,12,335)
Raodong31 = calraodong(df,12,347)
Raodong32 = calraodong(df,1,359)

raodongpieces = [Raodong1,Raodong2,Raodong3,Raodong4,Raodong5,Raodong6,
                     Raodong7,Raodong8,Raodong9,Raodong10,Raodong11,Raodong12,
                     Raodong13,Raodong14,Raodong15,Raodong16,Raodong17,Raodong18,
                     Raodong19,Raodong20,Raodong21,Raodong22,Raodong23,Raodong24,
                     Raodong25,Raodong26,Raodong27,Raodong28,Raodong29,Raodong30,
                     Raodong31,Raodong32]
Raodong = pd.concat(raodongpieces,axis=1,ignore_index=True)

Raodong.T.replace(np.nan,9999).to_csv('Raodong.txt')