Qualitative Data Cleaning & Frequencies
Budget: ₹600 – ₹1,500 INR
I have a single Excel workbook containing sentence-based categorical information extracted from 156 research articles. The raw sheet needs a thorough tidy-up—duplicate removal, consistent category naming, trimming of stray spaces or punctuation, and flagging any ambiguous entries so we can decide how to treat them.
Once the values are clean, I want a complete frequency table that summarises each distinct category with three statistics:
• Counts
• Percentages
• Cumulative percentages
Please place both the cleaned dataset and the finished frequency table in a brand-new worksheet inside the same workbook, leaving the original sheet untouched for traceability.
I am happy to answer any clarification questions up front so we can minimise back-and-forth later.
Once the values are clean, I want a complete frequency table that summarises each distinct category with three statistics:
• Counts
• Percentages
• Cumulative percentages
Please place both the cleaned dataset and the finished frequency table in a brand-new worksheet inside the same workbook, leaving the original sheet untouched for traceability.
I am happy to answer any clarification questions up front so we can minimise back-and-forth later.