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)
Processed:
0.017, SQL:
8
