Expert Data Specialist Needed - Large CSV Search & Excel Compilation
Budget: $30 – $250 USD
Description:
I’m looking for an experienced data specialist to process a large public dataset. The task involves unzipping and analyzing FOUR CSV/Excel files. You’ll perform targeted searches for 11 specific name variations, extract all relevant matches, and compile the verified results into a clean, formatted Excel file.
The FOUR file sizes are: 1.1 GB, 1.0 GB, 431 MB, and 159 MB.
MAX PAY: $100 USD
DUE DATE: This project is due within 72 hours of it being awarded.
ChatGPT Estimated Time: “8 –10 hours total for one capable freelancer working sequentially
(could stretch to 12 hours if system lag or manual Excel filtering is used instead of CSV tools).”
Responsibilities:
Unzip and open FOUR CSV/Excel datasets
Conduct exact and fuzzy searches for 11 provided terms (names)
Extract, verify, and format matched records
Ensure no duplicates and consistent structure
Upload completed work to Google Drive and delete local data
Deliverables:
One file containing all search matches.
Here are clean lists of minimum system requirements for both Windows and Mac users handling 1 GB+ SCO datasets:
Windows Minimum Requirements
Windows 10 (64-bit) or newer
Intel Core i5 (8th Gen or later) or AMD Ryzen 5 series
8 GB RAM minimum
SSD with at least 20 GB free space
1080p display resolution or higher
Microsoft Excel 2019 (64-bit) or Office 365
7-Zip or WinRAR v6+ for ZIP extraction
Stable internet: ≥ 40 Mbps download / ≥ 10 Mbps upload
Mac Minimum Requirements
macOS Big Sur 11.0 or newer
Apple M1 chip or Intel Core i5 (8th Gen or later)
8 GB RAM minimum
SSD with at least 20 GB free space
1080p display resolution or higher
Microsoft Excel 2019 (Mac 64-bit) or Excel 365
The Unarchiver or Keka for ZIP extraction
Stable internet: ≥ 40 Mbps download / ≥ 10 Mbps upload
Skill Tags:
Data Entry, Data Analysis, Excel, CSV Processing, Data Mining, Data Cleaning, Google Drive, Quality Assurance, File Management, Data Managemment
Screening Question:
Describe the largest CSV or Excel file you’ve successfully worked with (in MB or total records). What tools or methods did you use to search and filter the data efficiently?
-
I’m looking for an experienced data specialist to process a large public dataset. The task involves unzipping and analyzing FOUR CSV/Excel files. You’ll perform targeted searches for 11 specific name variations, extract all relevant matches, and compile the verified results into a clean, formatted Excel file.
The FOUR file sizes are: 1.1 GB, 1.0 GB, 431 MB, and 159 MB.
MAX PAY: $100 USD
DUE DATE: This project is due within 72 hours of it being awarded.
ChatGPT Estimated Time: “8 –10 hours total for one capable freelancer working sequentially
(could stretch to 12 hours if system lag or manual Excel filtering is used instead of CSV tools).”
Responsibilities:
Unzip and open FOUR CSV/Excel datasets
Conduct exact and fuzzy searches for 11 provided terms (names)
Extract, verify, and format matched records
Ensure no duplicates and consistent structure
Upload completed work to Google Drive and delete local data
Deliverables:
One file containing all search matches.
Here are clean lists of minimum system requirements for both Windows and Mac users handling 1 GB+ SCO datasets:
Windows Minimum Requirements
Windows 10 (64-bit) or newer
Intel Core i5 (8th Gen or later) or AMD Ryzen 5 series
8 GB RAM minimum
SSD with at least 20 GB free space
1080p display resolution or higher
Microsoft Excel 2019 (64-bit) or Office 365
7-Zip or WinRAR v6+ for ZIP extraction
Stable internet: ≥ 40 Mbps download / ≥ 10 Mbps upload
Mac Minimum Requirements
macOS Big Sur 11.0 or newer
Apple M1 chip or Intel Core i5 (8th Gen or later)
8 GB RAM minimum
SSD with at least 20 GB free space
1080p display resolution or higher
Microsoft Excel 2019 (Mac 64-bit) or Excel 365
The Unarchiver or Keka for ZIP extraction
Stable internet: ≥ 40 Mbps download / ≥ 10 Mbps upload
Skill Tags:
Data Entry, Data Analysis, Excel, CSV Processing, Data Mining, Data Cleaning, Google Drive, Quality Assurance, File Management, Data Managemment
Screening Question:
Describe the largest CSV or Excel file you’ve successfully worked with (in MB or total records). What tools or methods did you use to search and filter the data efficiently?
-
Related categories:
Data Processing
Data Entry
Excel
Data Mining
Data Cleansing
Data Extraction
Data Analysis
Data Management