删除指定行，指定内容的数据

最新推荐文章于 2024-02-27 21:47:52 发布

Small 涛涛

最新推荐文章于 2024-02-27 21:47:52 发布

阅读量648

点赞数 1

文章标签： python 大数据数据库数据挖掘数据分析

本文链接：https://blog.csdn.net/weixin_49967436/article/details/114987188

版权

删除前数据如下，.txt形式：
在这里插入图片描述

import re
import os
import numpy as np


x=[]
y=[]

with open("要删除文件名称.txt","r",encoding="GBK") as f:
    lines = f.readlines()
    #print(lines)
with open("11234.txt","w",encoding="GBK") as f_w:
    for line in lines:       #法二，如果’，‘不在一行，则删掉整行
        if "," not in line:
            continue
        if "SOURCE" in line:
            continue
        if "DATE" in line:
            continue
        f_w.write(line)
   # for line in lines:       #法一：删除指定行（一行一行删除）
   #     if "SOURCE" in line:
   #         continue
   #     if "DATE" in line:
   #         continue
   #     if "TIME" in line:
   #          continue
   #     if "SAMPLE" in line:
   #         continue
   #     if "SIGNAL" in line:
   #         continue
   #     if "DATA" in line:
   #         continue
   #     if "NUMBER" in line:
   #         continue
   #     if "CHANNEL" in line:
   #         continue
   #     if "HIT" in line:
   #        continue
   #    if ',' not in line:
   #         continue
   #     f_w.write(line)
   #

filename = '要删除文件名称.txt'
file=[line.strip().split(",") for line in open(filename)]
#print(file[0])
#print(file[1])
#print(file[2])      验证可省略


for d1,d2 in file:
    x.append(float(d1))
    y.append(float(d2))
print(x[1])
print(y[1])