Prompt Sloth Logo

Data Extraction

Scrape a table with 61 columns from a specified web page, collect data from all pages, and create a CSV file using a specific format and conditions. Clarifying questions are encouraged to ensure task completion confidence.

Analysis PromptsData ExtractionData CleaningWeb DevelopmentAdded: 9/5/2024

Prompt Navigator

Browse 959+ prompts by role, platform, task, or industry.

Prompts for Marketers

Brainstorm Ideas Customer Pain · Brainstorm Ideas Recent Experiences · Create Real Estate SEO

223

Prompts for Sales Teams

Business Development Strategy.md · B2B Sales Call Brief.md · Email Follow-Up Essentials

23

Prompts for Developers

Agility Story · Analyze Tech Impact · Explain Code

11

Prompts for Writers

Strategies for Clearing Creditors' Debit Balances · Copywriter

2

Email Prompts

Summarize Newsletter · Non-Profit Organization Guide · Scheduling Restrictions for Operations Support.md

36

Writing Prompts

Agility Story · Answer Question · Analyze Prose

387

Coding Prompts

Master Therapist Prompt · Agility Story · Coding Master

50

Analysis Prompts

Answer Question · Analyze Answers · Analyze Claims

260

Creative Prompts

Agility Story · Answer Question · Brainstorm Ideas Customer Pain

120

Business Prompts

Brainstorm Job Search Plan · Create Coding Project · Create Reading Plan

234

Prompts for Designers

Ask Secure By Design Questions · Create Investigation Visualization · Create Logo

223

Prompts for Founders

Extract Business Ideas · Extract Patterns · Starting Virtual Assistant Business

63

Prompts for Students

Create Academic Paper · Create Quiz · Create Reading Plan

76

Prompts for HR Teams

Analyze Threat Report · Analyze Threat Report Trends · Create Network Threat Landscape

18

ChatGPT Prompts

Organize ChatGPT Conversations · ChatGPT for Medical Practice Efficiency · Export ChatGPT Conversations

4

Midjourney Prompts

Craft Effective Midjourney Prompts

1

SaaS Prompts

Create SaaS Sales Proposal.md · Build Saas Product Guide

2

Ecommerce Prompts

Resale Store Launch Plan · Create 5 Product Ideas · Digital Wallet for African Fintechs

22

Real Estate Prompts

Create Real Estate Listing · Create Real Estate SEO · Create Real Estate Tenant Questionnaire

19

Finance Prompts

Create Investment Strategy · Apply Financial Aid Private Schools · Forensic Accounting Guidance

59

Healthcare Prompts

Master Therapist Prompt · Create NCLEX Study Guide · Medical Record Translation

46

Education Prompts

Create Quiz · Create Reading Plan · Summarize Study Material

67

Legal Prompts

Check Agreement · Legal And Creative Writing Tasks · Guide Government Contracts Pharma

25

HR & People Ops Prompts

Analyze Threat Report · Analyze Threat Report Trends · Create Network Threat Landscape

17

Therapy & Wellness Prompts

Master Therapist Prompt · Analyze Debate · Analyze Ikigai

71

Prompt Library

Answer Interview Question · Create NPC · Optimize Resume Keywords

50
Open in:
ChatGPT logoClaude logoPerplexity logo
Here is the ChatGPT prompt:

"Please perform the following tasks:

- Scrape the table found on the following web page, including all 61 columns: https://skyscraperpage.com/diagrams/?cityID=93.
- Ensure that data is scraped from all 3 pages of the table to include all rows.
- Create a CSV file from the scraped data using '|' as the separator.
- Use double quotes around strings that contain spaces.
- Include a headings row at the top of the CSV file.
- Include a row titles column in the CSV file.

Ask me clarifying questions until you are 95% confident you can complete the task successfully. Take a deep breath and take it step by step. Remember to search the internet to retrieve up-to-date information."

Related prompts