20220402help

import xlrd
import xlsxwriter
import os
import pandas as pd

# 文件夹名称
path = "linshi/"

# 获取文件目录
files = os.listdir(path)
print(files)

print(len(files))

# 读取第一个表格
data = pd.read_excel(path + files[0]
              #, index_col=0
             )
#data.head()

df = data.copy()

# 获得列表，为空行的人名

# name0 = df[df["学科"].isnull()]["name"].reset_index()
name0 = df[df["前收盘价(元)"].isnull()]["简称"].reset_index()
name1 = df[df["换手率(%)"].isnull()]["简称"].reset_index()
#print(name0)
#print(name1)
name0_1 = []
name1_1 = []
for i in range(len(name0)):
    name0_1.append(name0["简称"][i])
    print(name0["简称"][i])

for i in range(len(name1)):
    name1_1.append(name1["简称"][i])
    print(name1["简称"][i])

# 存放指定名称的列表，去重
list_name = list(set(name0_1).union(set(name1_1)))
print(list_name)
'''
for i in range(len(name0)):
    list_name.append(name0["简称"][i])
    print(name0["简称"][i])
'''

# 指定name的索引

indexNames=df[df['简称'].isin(list_name)].index
# data.query('a==1 | a==2')
# indexNames

# 

df = df.drop(indexNames).reset_index()
df.to_excel(path+"xin.xlsx", index=False)