Data entry

Offer description

I have several Excel workbooks containing historical NYC Airbnb listings and need them transformed into a clean, analysis-ready dataset that reveals clear, reliable averages for rental prices across boroughs, neighbourhoods, room types, and time periods. Here’s the flow I have in mind. First, import every sheet from the workbooks, standardise column names, parse date fields, and strip the text noise often found in host names, neighbourhood strings, and price columns. Next, handle missing values thoughtfully—no blanket deletions—so the final table truly represents the market. Once the data are tidy, I want a descriptive analysis that answers, at minimum, “What has the average nightly price looked like over time, and how does it differ by location and listing categ...

Skills and categories

Similar offers