| 12345678910111213141516171819202122232425262728293031 |
- #!/usr/bin/env python
- # -*- coding: utf-8 -*-
- '''
- 对instance数据按照cpu使用率降序排列
- @Auther :liuyuqi.gov@msn.cn
- @Time :8/13/2018 9:04 PM
- @File :sort_py_cpu.py
- '''
- import pandas as pd
- res = pd.DataFrame()
- appResources = pd.read_csv("../resb/app_resources.csv", header=None,
- names=list(["appid", "cpu", "mem", "disk", "P", "M", "PM"]), encoding="utf-8")
- instanceDeploy = pd.read_csv("../resb/instance_deploy.csv", header=None,
- names=list(["instanceid", "appid", "machineid"]), encoding="utf-8")
- instanceDeploy["cpu_avg"] = None
- tmp_cpu = appResources["cpu"].str.split('|', expand=True).astype('float')
- appResources["cpu_avg"] = tmp_cpu.T.mean().T
- h, l = instanceDeploy.shape
- print(h)
- # for i in range(0, h):
- # instanceDeploy["cpu_avg"][i] = appResources[appResources["appid"] == instanceDeploy["appid"][i]]["cpu_avg"].values[
- # 0]
- # if i % 1000==0:
- # print(i)
- # res["instanceid"] = instanceDeploy["instanceid"]
- # res["cpu"] = instanceDeploy["cpu_avg"]
- # res.sort_values(ascending=False, by="cpu", inplace=True)
- #
- # res.to_csv("../resb/app_cpu.csv", index=False, header=False)
|
