
Closed
Posted
Paid on delivery
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 category?” Python with pandas is my preferred toolkit, but R (tidyverse) is fine if that’s your strength. Visualisations created in Matplotlib, Seaborn, or ggplot2 should accompany the summary so the insights are instantly readable. Deliverables • Cleaned master Excel/CSV file ready for further modelling • Reproducible script or Jupyter Notebook with well-commented code • Short slide deck or PDF highlighting key findings and price trends Acceptance criteria: the notebook runs end-to-end on my machine without edits, numerical summaries match the visual output, and all steps—from raw import to final chart—are clearly documented. I’m open to bringing in supplementary CSV or JSON sources if you believe they’ll refine the story, but the core work must succeed with the Excel data already on hand.
Project ID: 40773953
67 proposals
Remote project
Active 14 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
67 freelancers are bidding on average ₹18,753 INR for this job

A few $9,999 placeholder prices and the same listing repeated across sheets will wreck borough averages; we catch and flag both. Day 1 you get the cleaned master file plus a one-page price-by-borough check so you can confirm the numbers look right. Full pandas notebook, charts and PDF by day 3, tested on a fresh install before handover. 1. Do the workbooks cover separate years, or do listings overlap between them? 2. Should averages be reported as mean only, or mean and median side by side? Send one workbook over chat and we can start today.
₹18,350 INR in 3 days
7.9
7.9

Hi There, Hope you are well. I will transform your NYC Airbnb Excel workbooks into a clean dataset, standardizing column names, handling missing values intelligently, and providing descriptive analysis on rental prices across boroughs, neighborhoods, and time periods using Python with pandas or R tidyverse. Deliverables include a cleaned file, script, and key findings presentation. Thanks in advance for the opportunity to working with you. Best Regards, Serazum
₹32,000 INR in 1 day
7.6
7.6

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
₹37,500 INR in 63 days
5.2
5.2

Hi, I notice that handling missing values in the NYC Airbnb listings dataset is crucial to get reliable averages for rental prices. I'd approach this by using Python with pandas to standardise column names and parse date fields. My focus will be on thoughtful handling of missing values to ensure the final table accurately represents the market. In my experience, a common mistake is blanket deletion of missing values, which can lead to biased results. I'll set up a reproducible script to import every sheet from the workbooks, clean the data, and perform descriptive analysis to answer key questions about average nightly prices over time and by location. The client can expect a cleaned master Excel/CSV file, a well-commented Jupyter Notebook, and a short slide deck highlighting key findings and price trends.
₹25,000 INR in 7 days
4.1
4.1

What decides whether your averages are "reliable" is how the price column and the missing values are handled. NYC Airbnb exports usually carry prices as text with $ and commas, relisted duplicate IDs, and neighbourhood strings spelled several ways, so a naive mean is skewed before the analysis even starts. I'd build a pandas pipeline that imports every sheet from every workbook, standardises column names, parses dates, and cleans the price, host and neighbourhood text. Missing values are treated field by field (imputed, flagged or excluded with a stated reason), not dropped wholesale, so the final table represents the market rather than only the complete rows. On top of that, a descriptive analysis of average nightly price over time, split by borough, neighbourhood and room type, with Matplotlib/Seaborn charts whose numbers tie back exactly to the summary tables. You get the cleaned master CSV/Excel, a commented Jupyter notebook that runs end to end on your machine without edits, and a short PDF of the key price trends. Two questions so the output fits your use: should extreme listings (e.g. $5,000+/night) be capped or reported separately, and is monthly or quarterly the better granularity for the trend view?
₹15,000 INR in 4 days
4.2
4.2

Hi, I can turn your Airbnb workbooks into a master dataset and a report showing how nightly prices vary across locations, room types and time periods. I’ll use pandas to combine the sheets and document the cleaning decisions. Missing prices need particular care: filling them with an average could distort the comparisons you want. I’ll show how many valid observations support each summary and flag groups with limited data. My portfolio includes “Sales Trend & Level-Shift Analysis,” a sample project using synthetic data to examine patterns over time. You’ll receive the cleaned Excel/CSV file, a documented notebook and a short PDF with charts. I’ll check that the notebook runs from start to finish and that the figures match the summary tables. I’d allow five days after receiving the files. How many workbooks are there, and approximately how many rows do they contain? Robert
₹12,500 INR in 5 days
3.7
3.7

I can turn your NYC Airbnb workbooks into one clean dataset using Python/pandas, with consistent columns, dates and numeric prices. I will document missing-value decisions rather than drop rows blindly, and distinguish genuine outliers from import errors. You will get cleaned Excel/CSV files, a reproducible notebook and a short PDF with matching price summaries and charts by time, borough, neighbourhood and room type. My price is ₹12,500 fixed for the complete described scope, delivered in 5 days after reviewing the workbooks and agreeing the cleaning rules. I will check outputs against the raw sheets and test the notebook in the agreed environment; work begins once the milestone is funded.
₹12,500 INR in 5 days
3.2
3.2

I’d handle this as a reproducible Python/Pandas data-cleaning and analysis workflow rather than manually modifying the workbooks. I would import all sheets, standardise the schema, clean price/date/text fields, handle duplicates and missing values explicitly, and then build the borough, neighbourhood, room-type and time-based rental-price analysis from the cleaned master dataset. My background is in Python development, automation and structured data processing, so I’d keep the notebook/script readable and repeatable rather than producing a one-off spreadsheet. I’ll provide the cleaned Excel/CSV dataset, documented Python analysis, visualisations that reconcile with the calculated summaries, and a concise PDF/slide summary of the important price trends. I can complete the first full version within 5 days.
₹17,500 INR in 5 days
2.8
2.8

Hi, This is cleaning work rather than entry work, and the difference matters: the averages you get at the end are only as good as how the messy rows were handled, so I'd rather show you the rules than the pivot table. What I'd do: load every sheet into Power Query and append them into one table, keeping a source column so any row can be traced back to the workbook it came from. Standardise column names once, then parse dates properly instead of leaving them as text. Prices get stripped to numbers - the currency symbol, the comma and the odd "per night" left inside the string are what break a SUM later, and they're easy to miss. Text noise in host names and neighbourhood strings I'd clean with a rule you approve rather than by hand: trim, collapse whitespace, fix obvious spelling variants, and where a neighbourhood appears under two spellings, map them to one and keep the original alongside so nothing is lost. Missing values I don't silently drop. You'd get a short table of what's missing, how many rows, and what I'd recommend per field, then I apply your decision. Deliverable: the clean table, a pivot-ready summary by borough, neighbourhood, room type and month, and a notes tab listing every rule I applied. How many workbooks and roughly how many rows? Rong
₹25,000 INR in 7 days
2.7
2.7

I’ll use pandas to combine every sheet, standardise columns, clean prices and text, and document how missing values are handled. I’ll check whether the dates support historical price trends, then compare average nightly rates by borough, neighbourhood, room type, and period. You’ll receive the cleaned Excel/CSV, a reproducible notebook with matching charts and summaries, and a short findings PDF. Do the workbooks contain dated snapshots of listings?
₹12,500 INR in 4 days
2.3
2.3

NYC Airbnb data has well-known traps for analysis: price stored as text with "$" and commas, listings with $0 or $10,000/night outliers, minimum_nights values in the hundreds, reviews_per_month blank when there are no reviews (that's 0, not missing), and the same listing repeated across historical snapshots. I'd consolidate the workbooks into one clean, typed table with a snapshot date column, de-duplicate by listing ID, flag outliers instead of silently deleting them, and document every cleaning rule. Is the goal a cleaned dataset only, or analysis and charts on top?
₹13,950 INR in 4 days
2.3
2.3

Hi! Your cleaned Airbnb dataset, notebook and charts, ready 3 days after your files arrive. You pay us nothing until you've seen the cleaned data. Here is what you get: • One master Excel/CSV file: every sheet combined, clean column names, dates parsed • Missing values filled with a stated rule per column, no blanket deletions • Average nightly price over time, by borough, neighbourhood and room type • A commented pandas notebook, tested end-to-end on a clean install, plus a short PDF of the findings Good to know: Airbnb prices often hold typos and extreme outliers. We flag them and show the averages with and without them. ✅ Included: 3 small changes within 3 weeks after you approve the work, and we fix any mistake of ours for free. Bonus: a one-page data dictionary listing every cleaning step and how many rows it touched. Our own demo: 45,716 rows of public data cleaned, and every row passed our checks. Price: ₹13,950 for the whole job. Do all your workbooks share the same column layout, or does it change between years? P.S. Oldrich, the owner, supervises the work and stands behind every result. We use various tools and AI agents to work fast and efficiently.
₹13,950 INR in 3 days
1.9
1.9

With my extensive professional experience of over 9+ years in the field of web and mobile development, I am confident that I can bring a great deal to your project. As a seasoned developer, I have honed my skills in working with Excel, Python, R and their related libraries such as pandas, tidyverse, Matplotlib, Seaborn and ggplot2 - all essential tools for effectively processing and analyzing data. Your project’s focus on transforming and analyzing Airbnb listing data is particularly intriguing to me. Being accustomed to handling large datasets like these across various industries gives me a unique edge that few others possess. I pay meticulous attention to detail while importing data by standardizing column names, parsing date fields and removing all possible text noise to ensure accuracy throughout the process - qualities vital for a project of this nature.
₹25,000 INR in 7 days
2.0
2.0

Average prices only mean something if the cleaning is defensible, so I'd treat missing values case by case, with no blanket deletions, and keep a log of every column fix: standardised names, parsed dates, stripped noise in host names, neighbourhoods and prices. Then pandas for averages by borough, neighbourhood, room type and period, with charts that match the numbers in the summary. You'd get the cleaned file, a notebook that runs end to end, and a short PDF of the findings. I haven't seen the workbooks yet. Do the sheets share the same columns across years, and which price field is the one to trust?
₹15,000 INR in 5 days
1.0
1.0

Hi, I can turn your Airbnb workbooks into a cleaned master dataset and reproducible pandas notebook, with summaries of nightly prices by borough, neighbourhood, room type and available time periods. I’ve built a CSV/Excel processing tool. I’d standardise columns, parse dates and prices, document missing-value decisions, and flag questionable records rather than applying blanket deletions. Deliverables would be the master Excel/CSV file, commented notebook, charts and a short PDF of findings. My bid is ₹12,500 with five-day delivery for the agreed supplied batch, covering descriptive analysis without additional data sources or predictive modelling. Could you share workbook/row counts and a representative sample before award so I can confirm the quote covers the complete batch? Please also confirm what the dates represent and how duplicate listings should be treated.
₹12,500 INR in 5 days
0.3
0.3

I understand you need several Excel workbooks transformed into a clean, analysis-ready dataset for historical NYC Airbnb listings. My proficiency in Python with pandas will allow me to efficiently standardize, clean, and analyze your data as you described. First, I will import all sheets, standardize column names, and clean any text noise to ensure accuracy. Once the data is tidy, I will provide insightful descriptive analyses and visualizations using Matplotlib or Seaborn. The deliverables will include a clean master Excel/CSV file, a well-commented Jupyter Notebook, and a PDF summarizing key findings. My structured approach will ensure reproducibility and clarity. Let’s connect to discuss further!
₹12,500 INR in 5 days
0.0
0.0

I can deliver 'Data entry ' end to end — clean architecture, tests, and deployment. I'll start with a short plan, share progress daily, and hand over production-ready code. Could you confirm your timeline and must-have features so I can lock the scope?
₹19,118.75 INR in 7 days
0.0
0.0

Hi there, I understand that you need a clean, analysis-ready dataset from your NYC Airbnb listings. I would begin by importing and standardizing the data in Python using pandas, ensuring that date fields are parsed correctly and text noise is eliminated. I will handle missing values carefully to maintain data integrity, allowing for reliable insights into rental price averages. Are there specific time periods or additional variables you want me to focus on during the analysis? I’m excited to help you visualize these trends and deliver the cleaned dataset along with a well-documented Jupyter Notebook. Best Regards, Charl
₹15,000 INR in 7 days
0.0
0.0

The biggest risk is price columns with text noise silently skewing the borough and neighbourhood averages. I'd strip that first, then address missing values thoughtfully rather than deleting them, which you called out by name. The cleaned file comes before the notebook, giving you 1 checkpoint to verify the numbers match your source before I build the charts. Send me the workbooks and I start with the cleaned master file.
₹36,800 INR in 10 days
0.0
0.0

Hi! Transforming your Excel workbooks into a comprehensive, analysis-ready dataset using Python and pandas aligns perfectly with my expertise. I'll ensure clean, coherent data for accurate insights, with clear visualizations using Matplotlib or Seaborn. Could we discuss any specific visualization preferences you have in mind?
₹25,000 INR in 7 days
0.0
0.0

Chennai, India
Member since Aug 15, 2026
$30-250 USD
$250-750 CAD
£250-750 GBP
$15-25 USD / hour
₹12500-37500 INR
$10-30 USD
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
$50-100 USD
₹4000-10000 INR / hour
$15-25 USD / hour
₹400-750 INR / hour
$10-30 USD
$2-8 USD / hour
$10-30 AUD
₹750-1250 INR / hour
$30-250 USD
$15-25 AUD / hour
$10-40 USD