Help scraping tables with pagination

How to?
#1

First time using the web scraper and I'm having a hard time setting up what I need and can't figure out from the tutorials.

What I want to do is to scrape the weather data in the last table for each day of the month.
Here is the site: Weather in January 2023 in Tokyo, Japan

table
table1245×631 34.2 KB

At the bottom are the pages for each day and I want to set it up to scrape the data for each day. Not sure if it's possible to also change the month after it's finished because it is in a drop down list at the top of the site.

month
month1238×263 18.1 KB

I have tried for the past 6 hours to set it up and can't figure out how to do it.
Any advice or help is more that welcomed.

The data will be used for a school project in analyzing weather data to find ideal times to visit Tokyo.

Thank you.

#2

Hi, here is your sitemap to collect data for first 3 months... Easy to change in EDIT METADATA:

{"_id":"weather","startUrl":["https://www.timeanddate.com/weather/japan/tokyo/historic?month=1&year=2023","https://www.timeanddate.com/weather/japan/tokyo/historic?month=2&year=2023","https://www.timeanddate.com/weather/japan/tokyo/historic?month=3&year=2023"],"selectors":[{"clickActionType":"real","clickElementSelector":".row .weatherLinks a","clickElementUniquenessType":"uniqueCSSSelector","clickType":"clickOnce","delay":400,"discardInitialElements":"do-not-discard","id":"click","multiple":true,"parentSelectors":["_root"],"selector":"body","type":"SelectorElementClick"},{"id":"date","multiple":false,"parentSelectors":["click"],"regex":"","selector":"h2#wt-his-title","type":"SelectorText"},{"id":"element","multiple":true,"parentSelectors":["click"],"selector":"div.sticky-wr .va-m tbody tr","type":"SelectorElement"},{"id":"time","multiple":false,"parentSelectors":["element"],"regex":"","selector":"th","type":"SelectorText"},{"extractAttribute":"title","id":"condition","multiple":false,"parentSelectors":["element"],"selector":"img.mtt","type":"SelectorElementAttribute"},{"id":"temp","multiple":false,"parentSelectors":["element"],"regex":"","selector":"td:nth-of-type(2)","type":"SelectorText"},{"id":"weather","multiple":false,"parentSelectors":["element"],"regex":"","selector":"td:nth-of-type(3)","type":"SelectorText"},{"id":"wind","multiple":false,"parentSelectors":["element"],"regex":"","selector":"td:nth-of-type(4)","type":"SelectorText"},{"extractAttribute":"title","id":"direction","multiple":false,"parentSelectors":["element"],"selector":"td:nth-of-type(5) span","type":"SelectorElementAttribute"},{"id":"humidity","multiple":false,"parentSelectors":["element"],"regex":"","selector":"td:nth-of-type(6)","type":"SelectorText"},{"id":"barometer","multiple":false,"parentSelectors":["element"],"regex":"","selector":"td:nth-of-type(7)","type":"SelectorText"},{"id":"visibility","multiple":false,"parentSelectors":["element"],"regex":"","selector":"td:nth-of-type(8)","type":"SelectorText"}]}