I am facinf below issues in IQ BOT 1)The table's rows are skipping (it jumps to the fourth record instead of the first row) 2) Single-row data are split and updated into two rows.

Thanks Tamil.

Could you please explain the below code.

# convert from dictionary to dataframe

df = pd.DataFrame.from_dict(table_values)

# print dataframe before update

print(df)

# Item_Description: drop rows with a missing value

df = df[(df["Item_Description"] != "")]

# Quantity: extract first part of the string, the numeric part only

df['Quantity'] = df['Quantity'].str.split(' ', 1).str[0].str.strip()

# print dataframe after update

print(df)

# convert back from dataframe to dict to override what IQ Bot stores

table_values = df.to_dict()

Can you please share it code with the IQ BOT logic screen and Error?

Hi Tamil,

My Issues is that rows are overlapping