pandas读取excel

最新推荐文章于 2024-08-26 22:31:41 发布

冰糖葫芦没有冰糖

最新推荐文章于 2024-08-26 22:31:41 发布

阅读量132

点赞数

分类专栏： Python

本文链接：https://blog.csdn.net/weixin_43931151/article/details/108908690

版权

Python 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

import pandas as pd
import os
import xlrd, xlwt
from xlutils.copy import copy as xl_copy

path = r'C:\Users\julie.wang\PycharmProjects\two\venv\Scripts'
file = 'test_number.xlsx'
file_path = os.path.join(path,file);
df = pd.read_excel(file_path, sheet_name="Sheet1", dtype =  str,  keep_default_na = False)
#
testsuite = df['testsuite']
nodes = df['nodes']
bin_number = df['bin_number']

print(testsuite)
print(nodes)
print(bin_number)