Python调用阿里云接口，实现数据清洗与可视化功能

import json
from aliyunsdkcore import client
from aliyunsdkecs.request.v20140526 import DescribeInstancesRequest

# 阿里云账号信息
access_key_id = "your_access_key_id"
access_key_secret = "your_access_key_secret"

# 创建API客户端实例
clt = client.AcsClient(access_key_id, access_key_secret, 'your_region_id')

# 创建请求对象
request = DescribeInstancesRequest.DescribeInstancesRequest()

# 发起API调用并处理响应
response = clt.do_action_with_exception(request)
result = json.loads(response)
instance_list = result['Instances']['Instance']

# 清洗数据
cleaned_data = []
for instance in instance_list:
    cleaned_data.append({
        'InstanceID': instance['InstanceId'],
        'InstanceName': instance['InstanceName'],
        'Status': instance['Status'],
        'PublicIP': instance['PublicIpAddress']['IpAddress'][0]
    })

# 输出清洗后的数据
for instance in cleaned_data:
    print(instance)

import matplotlib.pyplot as plt

# 统计不同状态的ECS实例个数
status_counts = {}
for instance in cleaned_data:
    status = instance['Status']
    if status not in status_counts:
        status_counts[status] = 1
    else:
        status_counts[status] += 1

# 生成饼图
labels = status_counts.keys()
sizes = status_counts.values()
plt.pie(sizes, labels=labels, autopct='%1.1f%%')
plt.axis('equal')  # 使饼图为正圆形
plt.title('ECS Instance Status Distribution')
plt.show()