Data Acquisition for Data Analyticss
Data acquisition is getting data into an analysis from outside sources: calling REST APIs, reading CSV, Excel and JSON files, and scraping web pages where permitted. It involves authentication, pagination, rate limits and checking the result for completeness. It follows Python on the Data Analytics path because real projects rarely start with neatly handed-over data.
Stage: Python or R for Analysis · Part of the Data Analytics roadmap · Last reviewed 19 November 2026
What to learn in Data Acquisition
- Request JSON from a REST API with the requests library and flatten it into a DataFrame
- Follow pagination until every page of results is collected
- Read Excel sheets and large CSV files in chunks with pandas
- Respect robots.txt, terms of service and rate limits when scraping
- Save raw pulls unchanged before any cleaning begins
Data Acquisition interview questions
Why keep the raw data file untouched and clean it in a separate step?
Raw files are the audit trail. If a cleaning rule turns out wrong you can rerun from the original, and others can reproduce your results. Editing the source in place destroys that and hides what changed between the source and your numbers.
An API returns 100 records per call and reports 2,340 in total. How do you collect them all?
Follow the API's pagination, whether page numbers, offsets or a next-cursor token, looping until no further page is returned. Respect rate limits with pauses, retry transient errors, and afterwards confirm that the row count matches the reported total.
Where Data Acquisition fits in the Data Analytics roadmap
Data Acquisition belongs to the Python or R for Analysis stage (beginner level), which takes about 5 hours. Scale beyond the sheet.
Other units in this stage
Back to the full Data Analytics roadmap