Data search
Technical Task: Analysis of Prices for Bus and Train Carriers in Europe
Objective
It is necessary to collect and analyze ticket prices for bus and train carriers across Europe to identify patterns and correlations between:
ticket price;
route distance;
route type;
departure time;
day of the week.
The result should show price ranges ("from–to")
What Needs to Be Done
1. List of Carriers
A list of carriers (approximately 70 companies) will be provided.
For each carrier, it is necessary to consider:
whether it is a domestic or international carrier;
what types of transport it uses:
buses;
trains;
or both options.
If a carrier has both buses and trains, we analyze both directions (for example, RegioJet)
2. Route Lengths
For each carrier, it is necessary to check from 5 to 10 routes of varying lengths:
Categories of Routes:
Short routes (20-100 km)
Medium routes (100-300 km)
Long routes (300-700+ km)
*these categories of routes are approximate. They work differently for each country, depending on the size of the country. It is important to test cities of varying distances to identify patterns in price formation according to distances.
Routes are selected based on the coverage of the specific carrier's operations.
3. Domestic and International Flights
If the carrier is domestic:
We check only domestic routes within the country.
If the carrier is international:
We check:
domestic flights;
international flights.
4. Exclusions (very important)
DO NOT consider:
routes with transfers;
combined routes;
partner flights of other operators;
aggregators and "foreign" offers.
Example:
In ALSA, on the route Madrid → Valencia, flights from other carriers may be displayed.
Such options are NOT included in the statistics.
If the site shows a flight from another operator, this needs to be indicated separately.
5. Only Direct Flights
Only direct routes are important.
If:
the route is available only with a transfer —
indicate separately:
"route with a transfer, price such-and-such".
But such data is not considered primary and is not used as base statistics.
6. Price Verification Parameters
Verification by Dates
For each route, we check a minimum of 3 scenarios:
1. Weekday
preferably about a week later;
not today/tomorrow;
the day of the week is not critical (Mon–Fri).
2. Weekend
Saturday or Sunday.
3. Urgent Purchase
today or tomorrow.
7. Verification by Departure Time
It is necessary to check the correlation of price with departure time.
We compare:
Night Flights
Approximately:
from 00:00 to 05:00
Daytime / Regular Flights
Approximately:
from 10:00 to 21:00
Important:
For some carriers, night flights are more expensive, for others — cheaper.
8. Price Format
Key Requirement:
The price should be indicated as a range:
"from–to"
can be a single number if all prices are the same
Example:
Daytime flights: €18–27
Night flights: €24–35
***It is not allowed to mix night and daytime prices into one range like 18-35. Day - a separate range. Night - a separate range
9. Currency
All prices should be converted to one currency:
either EUR
or USD
10. Nuances (important!)
If the carrier has:
discounts - if on a specific day there are many offers with discounts - we use this price in our range
anomalous prices - if at a specific time of day you see a route with an unreasonably high or low price and it is only one or a few ---- DO NOT use it in the price range, as it will skew the statistics. For the price (or price order) to be used in the range, it must occur at least a few times a day, then it is a pattern.
11. What Should Result
A table with the following data is needed:
carrier
type of transport
route
type of day (weekday / weekend / urgent) + prices from..to
departure and/or arrival time (night / day) + prices from..to
direct flight or transfer;
comments (discount, anomalous price, no direct routes, etc.)
Price by agreement.
Expensive solutions like parsers and scripts will be rejected, priority is to do it cheaply
-
129 Hello! I have experience in collecting, analyzing, and structuring data. I can start working on the tasks soon. I am waiting for the tasks!
-
387 1 0 Hello!
I have reviewed the technical assignment. The task is clear: it is necessary to conduct a systematic analysis of the pricing of European carriers (buses + railways) taking into account distance, type of connection, and time indicators.
I have the necessary skill set to complete this project:
Web Scraping (Python): Automated data collection from carrier websites (Selenium/Playwright), which will allow for quick processing of a significant number of routes.
Data Analysis (Pandas/Excel): Professional processing of data arrays, identifying correlations, and forming clear price ranges "from-to" according to your route categories.
…
For accurate timing calculations, I have two clarifications:
Do you already have a prepared list of 70 companies, or do some need to be selected independently?
For what period (booking depth) is it important to capture the price snapshot so that the analysis is relevant to your request?
I am ready to implement the project in the format of a structured table with graphs or summarized data for convenient visual analysis.
-
784 16 0 Hello, I have extensive experience in gathering information. I can complete your task. I can start in the near future. Please contact me.
-
909 7 0 Good day) I have experience in such attentive manual work with analysis, tables, and large volumes of data. I can quickly find the necessary information, filter out the excess, and neatly structure the results without confusion. I work carefully with details, so there will be no problems with checking flights, prices, and various nuances.
I have done similar tasks before, have good reviews in my profile, and examples of work in my portfolio. I also understand that it is important for you to do everything without expensive scripts and "budget manipulation" - I can perform this manually with quality and at a reasonable price. I provide the report in the format of a table + additionally a Word file with the details of the research.
Regarding the cost, it is approximately 1500–2000 UAH, and the timeframe is about 5–7 days, depending on the final volume. I can start almost immediately after discussing the details.
-
326 11 0 Good day. I am interested in your project. I am ready to discuss all the details and start working on it. I will do everything efficiently and quickly. Feel free to reach out.
-
1038 12 0 Hello! I have experience working with large volumes of data, spreadsheets, and gathering information from various sources, so I am ready for careful manual verification without using parsers. I work systematically and pay attention to details, so as a result, you will receive a neatly formatted table, structured according to all specified parameters. I would be happy to discuss the details and collaborate.
-
513 24 7 Good morning. I am interested in your order. I collaborate with many carriers and have completed similar tasks. There are no difficulties. Please feel free to reach out. I would be happy to cooperate. Best regards, Oksana. The price and deadline in the bid are current.
-
8275 153 1 3 Good day! 🧡
I am ready to start working and would be happy to help with minimal deadlines 😉
I have experience working on similar projects. 🌼 (I have reviews on this topic and work in my portfolio)
I will do it in the best way, I will start now! 🚀🛸✈️
Please write to me, we will discuss. I respond instantly!
-
1611 35 1 3 Good day! I am ready to start collaborating! I have experience in similar projects. *Details in private*
Attention! If I indicated "1111" or "777" in the total bid, it means I need more information to assess the project (also, deadlines may vary depending on the scope).
-
1318 2 0 Hello, I see the task of collecting prices from ~70 carriers in Europe. This is not just parsing, but analytics with clear rules for exceptions. I have done something similar for monitoring fuel prices at 200+ gas stations using httpx and asyncio - the script collected data every night, filtered duplicates, and exported to Google Sheets. The key here is to correctly filter out aggregator offers. How will you determine that a flight is foreign - by the logo on the website or is there a hidden API in the list of companies?
-
158 Ready to fully research all the data you need. I can also create the necessary visualization separately in the application.
-
3958 70 0 1 Good day!
I have extensive experience in both manual and automated data collection and processing of various kinds. You can view examples of completed projects and feedback on them in my profile, and more in private messages.
Examples of completed projects:
https://freelancehunt.com/project/analiz-konkurentiv/1500505.html
https://freelancehunt.com/project/zibrati-spisok-naykrutishih-programistiv/1493621.html
https://freelancehunt.com/project/rozsilka-rezyume-na-indeed/1403537.html
https://freelancehunt.com/project/zbir-bazi-potentsiynih-klientiv-dlya-autsorsingovogo/1436641.html
… Available for work, ready to start immediately after discussing the details of cooperation.
-
206 Good day, I am a content manager. I can professionally and qualitatively gather data. I have extensive research experience and am ready to start working. I have read and familiarized myself with the task. I can complete the work. Feel free to contact me!
-
3008 73 4 2 Good day! I am ready to carry out data collection according to your specifications with high quality!!! Feel free to contact me!!!
-
Вітаю)
Обирати маршрути між містами рандомно чи цікавлять якісь конкретні?
Чи враховувати вартість дитячих квитків, зручності (туалет, вайфай)?
Якщо однаковий маршрут у різних компаній займає різний час - це треба окремо занотувати?
Чи брати до уваги програми лояльності для постійних клієнтів?
Дякую -
Current freelance projects in the category Data Processing
Research AssistantWe are looking for a student or high school pupil who can find information on the internet and structure it neatly. What to do: - Search for necessary data on Instagram, TikTok, YouTube, Google, and other open sources - Enter results into Google Sheets, Google Docs What is… Data Processing, Information Gathering ∙ 13 hours 52 minutes back ∙ 9 proposals |
Adjustment of applications in CRM SalesDrive — one-time job for today (6–7 hours)
67 USD
A careful performer is needed for one-time work today. The task is to adjust applications in our CRM system (SalesDrive) according to the provided instructions: separate applications, process fiscal receipts, and write a comment for the application. Data Processing ∙ 2 days 16 hours back ∙ 22 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 5 days 20 hours back ∙ 19 proposals |
Analytics Setup
223 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 6 days 13 hours back ∙ 18 proposals |
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
89 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 8 days 2 hours back ∙ 18 proposals |