import pandas as pd
import numpy as np
# 导入数据
data = pd.read_excel("C:\\Users\\qianqian.wang\\Desktop\\测试代码文件夹\\BR-54751\\phone-size.xlsx")
data
# 也就是拥有93种不同的尺寸
data.shape
sum(data["screen_width"] > data["screen_height"]) # 66,黄色部分返回布尔值
# 设定手机宽是大于高的
for i in range(data.shape[0]):
if data.iloc[i,0]
temp = data.iloc[i,0]
data.iloc[i,0] = data.iloc[i,1]
data.iloc[i,1] = temp
data
按照某个字段排序
# 手机尺寸按照宽 从小到大排序
data = data.sort_values(by="screen_width",ascending=True)
data
修正索引
data.reset_index(drop=True,inplace=True) # 修正索引
data