问基于iloc和用户输入的Pandas数据检索

EN

with lite.connect(db_path) as db:

df = pd.read_sql_query('SELECT * FROM cond', conn)
print('What conductor are you analyzing?')

try:
    print(pd.read_sql_query('SELECT name FROM cond', conn)) # List names and Pandas IDs
    getCond = int(input('\nEnter the ID #: ')) # cast string to int to allow .iloc
    printSel = df.iloc[getCond]
    print()
    print(printSel)
    print(df[(df['Amps']) & (df.iloc == getCond)])

finally:
    if conn:
        conn.close()