I have difficulty to get final concat dataframe by try except for pymssql

Question

for i in Com_Tables:
try:
    frames = [pd.read_sql(f"SELECT * FROM {i}", conn).assign(ComId_Code = i)]

except:
    pass

finally:
    dfxilnex = pd.concat(frames)

i am expecting output to concat all data from each item in list however the result is showing only data for last item in list

score 0 · Accepted Answer · answered Feb 09 '23 at 06:48

0

You are not appending anything so there is nothing to concatnate. try this:

frames = []
for i in Com_Tables:
    try:
        frames.append(pd.read_sql(f"SELECT * FROM {i}", conn).assign(ComId_Code = i))

    except:
        pass

dfxilnex = pd.concat(frames)

answered Feb 09 '23 at 06:48

Serge de Gosson de Varennes

7,162
3
18
39

this solutions works beautifully...thanks @Serge_de_Gosson_de_Varennes – ZulH Feb 09 '23 at 07:24
@ZulH Glad it helped! Don't forget to accept and/or upvote the answer when you can. – Serge de Gosson de Varennes Feb 09 '23 at 07:25

I have difficulty to get final concat dataframe by try except for pymssql

1 Answers1