cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PanAna
New Member

Web Scrapping Music Charts

Dear friends, 

I am trying to scrapping a really tough table of data. 
The website is https://www.officialcharts.com/charts/official-hip-hop-and-r-and-b-singles-chart and the data we need to write on excel is : 

Pos
LW 
Artist 
Title
Deezer link
Spotify link

 

I have made a lot of tests with no luck!

What needed to fix is "LW" field in preview works fine, but the actual data returns empty, also "Deezer link" and "Spotify link" produces another row on excel, I need it on the same row with "Pos", "LW" etc. (see photos bellow).

Screenshot 2022-08-14 134950.pngScreenshot 2022-08-14 135151.pngScreenshot 2022-08-14 140053.png

I have learned so much from this message board I'm truly appreciate all of your assistance. 

 

Any assistance would be appreciated. 

 

Thanks in advance. 
PanAna

0 REPLIES 0

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Kudoed Authors
Users online (1,900)