【Python】pandas跳过若干行以及行数的获取方法

csv 获取到想要的行数,跳过若干行

file_name = 'xxx.xls'
title_list = '证券代码'
with open(file_name, 'r') as f:
    reader = csv.reader(f)
    for row_num, row in enumerate(reader):
        row_list = row[0].split('\t')
        if title_list in row_list:
            break

position_record_df = pd.read_csv(
    file_name, encoding='gbk',
    sep='\t',
    header=row_num - 1,
    skiprows=1
)

xlsx 获取到想要的行数,跳过若干行

row_num = 0
while mySheet.cell_value(nl,0) != "证券代码" :
    row_num += 1
position_record_df = pd.read_excel("CC.xlsx",skiprows=row_num)

获取需要要跳过的前面若干行

Excel样式