气象数据处理(1合并多个txt,2取出整数时间)
1. 合并多个txt
win +r 输入cmd
进入合并目录 type *.txt >>C:\hebing.txt合并后文件目录
2.替换字符串python
import re
import os
import csv
import array
import pandas
input_path = '000.txt' #原始文件路径 同一个文件夹不用写
output_path ='maohao.txt' #目标文件路径
with open(input_path) as input_file:
str = input_file.read() #读取文件
str = re.sub(':',',',str) #用逗号替换冒号
with open("maohao.txt", "w", encoding='utf-8') as f:
f.write(str)
f.close()
- 整点文件输出
import re
import os
import csv
import array
import pandas
output_path2 ='maohao1.txt'
with open('maohao.txt','r') as df:
table=[]#开个列表
for line in df:
col = line.split(',')#把每列数据分割开
col1= float(col[1]) #把第4列的用float类型存
col2= float(col[2]) #把第4列的用float类型存
col3= float(col[3]) #把第4列的用float类型存
col4= str(col[4]) #把第4列的用float类型存
if col2 == 0 and col3 ==0 and col4 == "0R1":
all_lines = line
#print(all_lines)
with open(output_path2, 'a+') as output_file:
output_file.write(all_lines)
温度
import re
import os
import csv
import array
import pandas
output_path2 ='wendu.txt'
with open('maohao.txt','r') as df:#####打开文件
table=[]#开个列表
for line in df:
col = line.split(',')#把每列数据分割开
col1= float(col[1]) #把第4列的用float类型存
col2= float(col[2]) #把第4列的用float类型存
col3= float(col[3]) #把第4列的用float类型存
col4= str(col[4]) #把第4列的用float类型存
if col2 == 0 and col4 == "0R2":
all_lines = line
#print(all_lines)
with open(output_path2, 'a+') as output_file:
output_file.write(all_lines)
湿度1
import re
import os
import csv
import array
import pandas
output_path2 ='shidu.txt'
output_path3 ='shidu1.txt'
with open('maohao.txt','r') as df:#####打开文件
table=[]#开个列表
for line in df:
col = line.split(',')#把每列数据分割开
col1= float(col[1]) #把第4列的用float类型存
col2= float(col[2]) #把第4列的用float类型存
col3= float(col[3]) #把第4列的用float类型存
col4= str(col[4]) #把第4列的用float类型存
if col2 == 0 and col4 == "0R5":
all_lines = line
#print(all_lines)
with open(output_path2, 'a+') as output_file:
output_file.write(all_lines)
湿度2
import re
import os
import csv
import array
import pandas
output_path2 ='shidu1.txt'
i = 0
with open('shidu.txt','r') as df:
table=[]#开个列表
for line in df:
i = i+1
t = i%4
if t ==0 :
all_lines = line
#print(all_lines)
with open(output_path2, 'a+') as output_file:
output_file.write(all_lines)