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.
Hi @Lavanya Anbuselvan ,
Would you be able to share the screen shot of the table here?
Please find the below
IQ Bot 11.x: Table fields - Automation Anywhere Documentation
IQ Bot 11.x: Map a table - Automation Anywhere Documentation
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
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()
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
I am fetting error as "nameError : name 'table_values' is not defined : File "<string>", line 3, in <module>\n'"
Please try the below code
import pandas as pd
df = pd.DataFrame.from_dict(table_values)
df = df[(df["Item_Description"] != "")]
df['Quantity'] = df['Quantity'].str.split(' ', 1).str[0].str.strip()
table_values = df.to_dict()
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
Hi Tamil,
My Issues is that rows are overlapping
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.