pandas练习1

最新推荐文章于 2024-10-08 12:37:10 发布

乐寒儒

最新推荐文章于 2024-10-08 12:37:10 发布

阅读量100

点赞数

分类专栏： Python 文章标签： python

本文链接：https://blog.csdn.net/lehanru/article/details/109590162

版权

Python 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

import pandas as pd
import os
import re
df ={}
for filename in os.listdir(os.getcwd()):
    datetime = re.findall(r"2020\d{4}",filename,re.I)
    if datetime:
        df[str(datetime[0])] = pd.read_csv(filename)
i = 0
for datatime,datainfo in df.items():
    # 只取GSU数据
    datainfo = datainfo[datainfo["vmName"].str.contains("GSU")]
    i+=1
    if i == 1:
        df_memoryFree = datainfo.loc[:,["vmName","memoryFree"]] 
        df_memoryFree.rename(columns={"memoryFree":datatime },inplace=True)
        continue
    else:
        df_memoryFree_tmp = datainfo.loc[:,["vmName","memoryFree"]]
        df_memoryFree_tmp.rename(columns={"memoryFree":datatime },inplace=True)
        df_memoryFree = df_memoryFree.merge(df_memoryFree_tmp,on="vmName",how="right")
# 行列转置
df_memoryFree = pd.DataFrame(df_memoryFree.values.T, index=df_memoryFree.columns, columns=df_memoryFree.index)
print(df_memoryFree)