import xlwt
#xlwt写入excel中每个sheet最多大概为五万行,所以需要大致知道打开的文档有多少行
f = open('123.txt','r')
data = f.readlines()
#按行读取txt数据,data为list类型
print(len(data))
#len(data)为文本文档的数据行数
#2794729
f.close()
B = []
for line in data:
first = line.strip('\n')
second = first.split(' ')
A = [i for i in second if i != ""]
# 先循环遍历有空值的列表,并抽取非空的列表元素,存储到新的列表中;踢掉空元素
B.append(A)
import xlwt
f = open('123.txt','r')
data = f.readlines()
print(len(data))
f.close()
B = []
for line in data:
first = line.strip('\n')
second = first.split(' ')
A = [i for i in second if i != ""]
# 先循环遍历有空值的列表,并抽取非空的列表元素,存储到新的列表中
B.append(A)
C = []
for i in range(len(B)):
try:
if B[i][3] == '184'