FilesExpand file tree

 master

/

get_range.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

executable file

·

31 lines (26 loc) · 1.26 KB

 master

/

get_range.py

Copy path

Top

File metadata and controls

• Code
• Blame

executable file

·

31 lines (26 loc) · 1.26 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

#!/usr/bin/python3

# -*- coding: utf-8 -*-

# Author: xurongzhong#126.com

# CreateDate: 2018-1-8

# check_md5.py

import argparse

import pandas as pd

parser = argparse.ArgumentParser()

parser.add_argument('filename', action="store", help='要处理的结果文件')

parser.add_argument('colomns', action="store", help='列名用逗号分隔')

parser.add_argument('colomn', action="store", help='要处理的列名')

parser.add_argument('low', action="store", help='低值',type=float)

parser.add_argument('high', action="store", help='高值',type=float)

parser.add_argument('-o', action="store", dest="output",

default="output.csv", help='输出文件名，默认为output.csv')

parser.add_argument('-S', action="store", dest="sep",

default="\s", help=r'分隔符，默认为\s')

parser.add_argument('--version', action='version',

version='%(prog)s 1.1 Rongzhong xu 2018 04 19')

options = parser.parse_args()

#names = options.colomns.split(",")

df = pd.read_csv(options.filename, sep=options.sep)

print(df)

#df = df.loc[1:,:]

df1 = df.loc[(df[options.colomn].astype('float') < options.high) & (df[options.colomn].astype('float') > options.low)]

df1.to_csv(options.output, index=None)