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.

Page 1 / 1

Would you be able to share the screen shot of the table here?

Please find the below

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

dfp'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()

I am fetting error as "nameError : name 'table_values' is not defined : File "<string>", line 3, in <module>\n'"

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

Please try the below code

import pandas as pd

df = pd.DataFrame.from_dict(table_values)

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

dff'Quantity'] = dff'Quantity'].str.split(' ', 1).strr0].str.strip()

table_values = df.to_dict()

Hi Tamil,

My Issues is that rows are overlapping

Sign up