IMDB Data Scrapping

Learn Academy Feedback
1

Hello,

I wanted to scrap data from IMDB.

I wanted to review games on basis of their ratings. If rating is >=9.0 then “good”, if rating is <9.0 and >8.7 then “avg” else rating is <8.7 then “bad”

So, I have scrapped first 1000 pages from IMDB and I wanted this data in csv in 3 columns.

  1. NameofGame
  2. Ratings.
  3. FinalReview

I have created workflow but I am getting an error on if condition.(can not find Column 3)

image

Main.xaml (22.4 KB)

Please help on above workflow.

2

@Shubhankar_Gadekar

I checked your workflow and it looks good except one thing. Actually Column Index will start from ‘0’ here. So, use row(2) instead of row(3) for final review column.

1 Like
3

Thank You. It worked.

1 Like
4

Hi Shubhankar,

When you get row items, use Column names(row(“FinalReview”)) instead of index. Because column index may changed in future. In this case it was fine. But when you read others excel, they might be changed the index of the columns. So you get wrong answers.

Thanks,
Michael

1 Like
5

Hi Michael,

Yes, this will be a good approach.I will follow this practice.
Thank you for help.

Thanks,
Shubhankar

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.