CN116757728B - Method and related device for processing sales data of historical flights - Google Patents

Method and related device for processing sales data of historical flights Download PDF

Info

Publication number
CN116757728B
CN116757728B CN202311034903.7A CN202311034903A CN116757728B CN 116757728 B CN116757728 B CN 116757728B CN 202311034903 A CN202311034903 A CN 202311034903A CN 116757728 B CN116757728 B CN 116757728B
Authority
CN
China
Prior art keywords
cabin
sales data
historical
class
classes
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202311034903.7A
Other languages
Chinese (zh)
Other versions
CN116757728A (en
Inventor
杨勃
孙琼巍
王忠韬
杨玲
杭南
郭璐
王泉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Travelsky Technology Co Ltd
Original Assignee
China Travelsky Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Travelsky Technology Co Ltd filed Critical China Travelsky Technology Co Ltd
Priority to CN202311034903.7A priority Critical patent/CN116757728B/en
Publication of CN116757728A publication Critical patent/CN116757728A/en
Application granted granted Critical
Publication of CN116757728B publication Critical patent/CN116757728B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data

Landscapes

  • Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Finance (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Game Theory and Decision Science (AREA)
  • Data Mining & Analysis (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application discloses a processing method and a related device for sales data of historical flights, in particular to a method for acquiring the sales data of the historical flights; determining abnormal flights with jump cabin sales data in the sales data of the historical flights; acquiring historical seat booking data of an abnormal flight; and processing the cabin-skipping sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data, thereby realizing processing of the cabin-skipping sales data in the sales data of the historical flight.

Description

Method and related device for processing sales data of historical flights
Technical Field
The application relates to the technical field of data processing, in particular to a method and a related device for processing sales data of historical flights.
Background
With the rapid development of aviation business, airlines generate more and more sales data in the sales process, and accurate historical flight sales data is an important basis for airlines to make future sales plans, make sales indexes and make sales decisions. However, due to the manual control of the cabin sales data during the sales process, the sales data of the historical flights inevitably deviate, and if the jump cabin sales data in the sales data of the historical flights cannot be processed in time, decision errors may be caused in making decisions of future flights.
Therefore, how to provide a solution for processing the jump cabin sales data in the sales data of the historical flights is a problem that needs to be solved by those skilled in the art.
Disclosure of Invention
In view of the above problems, the present application provides a method and a related device for processing sales data of historical flights, so as to achieve the purpose of processing skip cabin sales data in the sales data of the historical flights. The specific scheme is as follows:
a method of processing sales data for a historical flight, comprising:
acquiring sales data of historical flights;
determining abnormal flights with jump cabin sales data in the sales data of the historical flights;
acquiring historical seat booking data of an abnormal flight;
and processing the jump cabin sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data.
A processing apparatus for sales data of a historic flight, comprising:
a first acquisition unit configured to acquire sales data of a historical flight;
the first processing unit is used for determining abnormal flights with jump cabin sales data in the sales data of the historical flights;
the second acquisition unit is used for acquiring historical seat booking data of the abnormal flight;
and the second processing unit is used for processing the jump cabin sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data.
An electronic device comprising at least one processor and a memory coupled to the processor, wherein:
the memory is used for storing a computer program;
the processor is configured to execute the computer program to enable the electronic device to implement the method for processing sales data of historical flights.
A computer storage medium carrying one or more computer programs which, when executed by an electronic device, enable the electronic device to implement the method of processing sales data for historical flights described above.
By means of the technical scheme, in the method for processing the sales data of the historical flights, the sales data of the historical flights are obtained; determining abnormal flights with jump cabin sales data in the sales data of the historical flights; acquiring historical seat booking data of an abnormal flight; and processing the cabin-skipping sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data, thereby realizing processing of the cabin-skipping sales data in the sales data of the historical flight.
Drawings
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
FIG. 1 is a flow chart of a method for processing sales data of historical flights provided by the application;
FIG. 2 is a flowchart of a process for determining jump cabin sales data in a method for processing sales data of historical flights provided by the application;
FIG. 3 is a flowchart of acquiring historical seat booking data of an abnormal flight in a method for processing sales data of a historical flight provided by the application;
FIG. 4 is a flowchart of processing jump cabin sales data in a method for processing sales data of historical flights provided by the application;
FIG. 5 is a schematic diagram of a device for processing sales data of historical flights according to the present application;
fig. 6 is a schematic structural diagram of an electronic device according to the present application.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure have been shown in the accompanying drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.
The term "including" and variations thereof as used herein are intended to be open-ended, i.e., including, but not limited to. The term "based on" is "based at least in part on"; the term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments. Related definitions of other terms will be given in the description below.
It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.
It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.
Example 1
The embodiment of the application provides a method for processing sales data of historical flights, which can be applied to various system platforms, wherein an execution subject of the method can be a processor of a computer terminal or various mobile devices, and a flow chart of the method is shown in fig. 1, and specifically comprises the following steps:
S10, acquiring sales data of historical flights.
In this embodiment, the sales data of the historical flights need to be acquired, and the sales data of the corresponding historical flights may be acquired according to specific processing needs, specifically, the date of acquiring the sales data of the historical flights may be a flight 24:00 later than the departure date, and the time range of acquiring the historical flights is at least 5 weeks, that is, the time interval from the first flight of the acquired historical flights to the last flight of the acquired historical flights is at least 5 weeks from the information of all the acquired historical flights, so that the data period of the sales data of the historical flights needed to be acquired in the embodiment of the present application is satisfied.
S20, determining that abnormal flights of the cabin-jump sales data exist in the sales data of the historical flights.
In this embodiment, it is required to determine that an abnormal flight of the flight sales data exists in the sales data of the historical flights.
Referring to fig. 2, fig. 2 shows a process for determining cabin-jump sales data from sales data of historical flights, which is provided by the embodiment of the application, specifically including the following steps:
s201, acquiring sales data of each cabin level of the historical flight.
In this embodiment, sales data of each class of historical flights is acquired. Taking the economy class as an example for description, assume that the prices of the economy class are F respectively 1 、F 2 ……F n Wherein F 1 >F 2 >……F n The sales data corresponding to each cabin level is S 1 、S 2 ……S n
S202, determining any adjacent N cabin classes in each cabin class of the historical flight as the associated cabin class of the first cabin class in the N cabin classes, and determining the sum of sales data of the N cabin classes as the associated sales data of the first cabin class in the N cabin classes.
In this embodiment, it is necessary to determine any adjacent N cabin classes among the cabin classes of the historical flight as the associated cabin class of the first cabin class of the N cabin classes, and determine the sum of sales data of the N cabin classes as the associated sales data of the first cabin class of the N cabin classes.
Illustratively, describing N as being equal to 3, in this embodiment, for each of the economy class, any adjacent 3 classes are determined as being associated with the first of the 3 classes, and the sum of sales data for the 3 classes is determined as being associated sales data for the first of the 3 classes.
For example, define a set of data A 1 、A 2 ……A n-2 Wherein A is 1 Representative sales data is S 1 Associated sales data of corresponding class, A 2 Representative sales data is S 2 Associated sales data of corresponding class, A n-2 Representative sales data is S n-2 Corresponding cabin-level association pinsSales data, i.e. A 1 =S 1 +S 2 +S 3 ,A 2 =S 2 +S 3 +S 4 ,……,A n-2 =S n-2 +S n-1 +S n
S203, determining the maximum value of the associated sales data of the target cabin class, wherein the target cabin class comprises other cabin classes except the first M cabin classes with the sales data arranged from high to low in each cabin class of the historical flights, and M=N-1.
In this embodiment, the maximum value of the associated sales data defining the target cabin class is A max The destination class includes other classes than the first M classes of the historical flights in which sales data is ranked from high to low, where m=n-1.
Illustratively, since the description above is given by taking N equal to 3 as an example, if M is equal to 2, then the maximum value a of the associated sales data of the target class is determined max When the associated sales data corresponding to the first 2 cabin classes with the highest cabin class level need to be removed, specifically, the associated sales data A is determined 1 、A 2 ……A n-2 Maximum value A of (a) max When the first 2 cabin classes corresponding to the highest cabin class are required to be removed, the associated sales data A 1 And A 2 Therefore only A needs to be determined 3 To A n-2 Maximum value A of (2) max Can be, namely A max And the value of max is from 3 to n-2.
Similarly, if N is equal to 4, M is equal to 3, and the maximum value A of the associated sales data of the target cabin class is determined max When the associated sales data corresponding to the first 3 cabin classes with the highest cabin class level need to be removed, specifically, the associated sales data A is determined 1 、A 2 ……A n-2 Maximum value A of (a) max When the first 3 cabin classes with the highest cabin class levels are corresponding to the associated sales data A needs to be removed 1 、A 2 And A 3 Therefore only A needs to be determined 4 To A n-2 Maximum value A of (2) max Can be, A max And the value of max is from 4 to n-2.
S204, aiming at other cabin levels except the target cabin level, judging whether the associated sales data of the other cabin levels are larger than the maximum value of the associated sales data of the target cabin level, and judging whether the associated sales data of the other cabin levels are larger than the associated sales data of the cabin level with the highest sales data in the cabin levels of the historical flights.
In this embodiment, according to a preset threshold range of the passenger seat rate, for other cabin classes except the target cabin class, whether the associated sales data of the other cabin classes is greater than the maximum value of the associated sales data of the target cabin class is determined, and whether the associated sales data of the other cabin classes is greater than the associated sales data of the cabin class with the highest sales data among the cabin classes of the historical flights is determined.
Specifically, for flights with passenger seat rates higher than a set threshold range, for other cabin classes before the cabin class corresponding to the maximum value of the associated sales data of the target cabin class, whether the associated sales data of the other cabin classes is larger than the maximum value of the associated sales data of the target cabin class is judged, and whether the associated sales data of the other cabin classes is larger than the associated sales data of the cabin class with the highest sales data among the cabin classes of the historical flights is judged.
Illustratively, flights with passenger seat rates higher than 99% are taken as an example, and the above steps determine the maximum value A of the target cabin class associated sales data max Is A i Defining the jump cabin sales data as A j The implementation needs to judge the jump cabin sales data A j Whether or not to meet A j <x×A max And A is j <x×A 1 Where x is a coefficient, and is adjustable according to a range of a set passenger seat rate, in this embodiment, x=3 is taken as an example to describe, so that implementation needs to determine the jump cabin sales data a j Whether or not to meet A j <3×A max And A is j <3×A 1 Wherein j has a value from 2 to i-1.
Specifically, for flights with passenger seat rates lower than the set threshold range, for other cabin classes after the cabin class corresponding to the maximum value of the associated sales data of the target cabin class, whether the associated sales data of the other cabin classes is larger than the maximum value of the associated sales data of the target cabin class is judged, and whether the associated sales data of the other cabin classes is larger than the associated sales data of the cabin class with the highest sales data among the cabin classes of the historical flights is judged.
Illustratively, flights with passenger seats less than 65% are taken as an example, and the above steps determine the maximum value A of the associated sales data of the target class max Is A i Defining the jump cabin sales data as A j The implementation needs to judge the jump cabin sales data A j Whether or not to meet A j <x×A max And A is j <x×A 1 Where x is a coefficient, and is adjustable according to a range of a set passenger seat rate, in this embodiment, x=3 is taken as an example to describe, so that implementation needs to determine the jump cabin sales data a j Whether or not to meet A j <3×A max And A is j <3×A 1 Wherein j takes on values from i+1 to n-2.
S205, if the associated sales data of other cabin levels are judged to be larger than the maximum value of the associated sales data of the target cabin level, and the associated sales data of other cabin levels are larger than the associated sales data of cabin levels with highest sales data in each cabin level of the historical flights, the sales data of N cabin levels corresponding to the associated sales data of other cabin levels are all jump cabin sales data, and it is determined that flights containing jump cabin sales data in the historical flights are abnormal flights.
In this embodiment, if it is determined that the associated sales data of other cabin levels is greater than the maximum value of the associated sales data of the target cabin level, and the associated sales data of other cabin levels is greater than the associated sales data of cabin levels with the highest sales data among the cabin levels of the historical flights, the sales data of the N cabin levels corresponding to the associated sales data of other cabin levels are all skip cabin sales data a j And determines that the historical flights contain jump cabin sales data A j Is an anomalous flight.
Specifically, since the embodiment of the present application is divided into two cases according to the passenger seat rate of the historical flights, namely, the historical flights with passenger seat rates higher than the threshold range and the historical flights with passenger seat rates lower than the threshold range, it is possible to identify that the jump cabin sales data A is included in both cases j And therefore, the abnormal flight containing the jump cabin sales data A is determined by the two conditions j Abnormal flight merger of (C)And finally obtaining all abnormal flights containing the jump cabin sales data in the historical flights.
S30, acquiring historical seat booking data of the abnormal flight.
Referring to fig. 3, fig. 3 shows a flowchart for acquiring historical seat booking data of an abnormal flight in a method for processing sales data of a historical flight according to an embodiment of the present application, which specifically includes the following steps:
s301, acquiring a historical booking average value of an abnormal flight at each preset acquisition time point, judging invalidity of each historical booking average value, and carrying out data correction on the invalid historical booking average value.
In this embodiment, a historical booking average value of an abnormal flight at each preset collection time point is obtained, invalidation judgment is performed on each historical booking average value, and data correction is performed on the invalid historical booking average value.
Specifically, for each preset collection time point, based on the historical booking data of each abnormal flight at the preset collection time point, counting the booking total number of the preset collection time points, based on the booking total number and the number of the abnormal flights, calculating to obtain a historical booking average value of the preset collection time point, performing invalidation judgment on each historical booking average value, and performing data correction on the invalid historical booking average value. The data correction process comprises the following steps: determining a historical seat booking average value which is the closest to the preset acquisition time point and is judged to be an effective value before the preset acquisition time point corresponding to the historical seat booking average value in the historical seat booking average values as a first target historical seat booking average value; determining a second target historical seat booking average value, wherein the second target historical seat booking average value is determined by the historical seat booking average value which is the closest to the preset acquisition time point corresponding to the historical seat booking average value in the preset acquisition time points and is determined to be a valid value; and calculating the average value of the first target historical seat reservation average value and the second target historical seat reservation average value, and taking the calculated average value as a value obtained by carrying out data correction on the historical seat reservation average value.
S302, based on the historical booking average value after data correction and the historical booking average value determined to be an effective value, booking data of abnormal flights is obtained.
In this embodiment, the seat reservation data of the abnormal flight is obtained by combining the history seat reservation average value after the data correction and the history seat reservation average value determined to be the effective value.
S40, processing the jump cabin sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data.
In this embodiment, the jump cabin sales data is processed according to the historical seat reservation data of the abnormal flight obtained in the step S30 to obtain the processed sales data.
Referring to fig. 4, fig. 4 shows a flowchart of processing jump cabin sales data in a method for processing sales data of historical flights according to an embodiment of the present application, which specifically includes the following steps:
s401, obtaining the sum of the booking numbers of the cabin levels corresponding to the cabin jump sales data in the abnormal flights according to the booking data of the abnormal flights.
In this embodiment, the sum of the final booking numbers of the cabin class corresponding to the jump cabin sales data in the abnormal flight is defined as S hisfull S is then hisfull =S his1 +S his2 +…+S hisn
S402, obtaining the sum of the jump cabin sales data of the abnormal flight according to the jump cabin sales data of the abnormal flight.
In this embodiment, the sum of the jump cabin sales data defining the abnormal flight is S full S is then full =S 1 +S 2 +…+S n
S403, obtaining sales data of average seat number of the cabin class corresponding to the cabin jump sales data in the abnormal flight according to the sum of the cabin jump sales data of the abnormal flight and the sum of the seat number of the cabin class corresponding to the cabin jump sales data in the abnormal flight.
In this embodiment, sales data of an average number of seats of a class corresponding to the sales data of the jumped cabin in the abnormal flight is obtained according to a sum of sales data of the jumped cabin of the abnormal flight and a sum of numbers of seats of a class corresponding to the sales data of the jumped cabin in the abnormal flight.
Specifically, the sum S of the jump cabin sales data of the abnormal flight full Dividing the sum S of the number of seats of cabin class corresponding to the jump cabin sales data in the abnormal flight hisfull Obtaining the sales data of the average booking number of the cabin class corresponding to the cabin jump sales data in the abnormal flight, and defining the sales data as S ratio S is then ratio =S full ÷S hisfull
S404, obtaining processed sales data according to the sales data of the average booking number of the cabin class corresponding to the cabin jump sales data in the abnormal flight and the booking number of the cabin class corresponding to the cabin jump sales data in the abnormal flight.
In this embodiment, the processed sales data is obtained according to the sales data of the average number of seats of the cabin class corresponding to the cabin jump sales data in the abnormal flight and the number of seats of the cabin class corresponding to the cabin jump sales data in the abnormal flight.
Specifically, the booking number S of the cabin class corresponding to the jump cabin sales data in the abnormal flight hisi Sales data S sequentially multiplied by average number of seats of class corresponding to jump cabin sales data in abnormal flight ratio Obtaining processed sales data, defining the processed sales data as S newi S is then newi =S ratio ×S hisi I has a value from 1 to n.
In this embodiment, the sales data after the output processing is S new1 、S new2 、……、S newi
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.
Although operations are depicted in a particular order, this should not be understood as requiring that such operations be performed in the particular order shown or in sequential order. In certain circumstances, multitasking and parallel processing may be advantageous.
It should be understood that the various steps recited in the method embodiments of the present disclosure may be performed in a different order and/or performed in parallel. Furthermore, method embodiments may include additional steps and/or omit performing the illustrated steps. The scope of the present disclosure is not limited in this respect.
Computer program code for carrying out operations of the present disclosure may be written in one or more programming languages, including, but not limited to, an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
Example two
Fig. 5 shows a schematic structural diagram of a processing device for sales data of historical flights according to an embodiment of the present application.
As shown in fig. 5, the processing device for providing sales data of historical flights according to the embodiment of the present application specifically includes:
a first acquiring unit 501 configured to acquire sales data of a historical flight;
the first processing unit 502 is configured to determine that abnormal flights of the flight sales data exist in the sales data of the historical flights;
a second obtaining unit 503, configured to obtain historical seat booking data of an abnormal flight;
and the second processing unit 504 is configured to process the cabin-jump sales data according to the historical seat reservation data of the abnormal flight to obtain processed sales data.
The processing device for the sales data of the historical flights provided by the embodiment of the application acquires the sales data of the historical flights; determining abnormal flights with jump cabin sales data in the sales data of the historical flights; acquiring historical seat booking data of an abnormal flight; and processing the cabin-skipping sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data, thereby realizing processing of the cabin-skipping sales data in the sales data of the historical flight.
In one embodiment of the present application, based on the foregoing scheme, the first processing unit 502 is specifically configured to:
Acquiring sales data of each cabin level of historical flights;
determining any adjacent N cabin classes in each cabin class of the historical flight as the associated cabin class of the first cabin class in the N cabin classes, and determining the sum of sales data of the N cabin classes as the associated sales data of the first cabin class in the N cabin classes;
determining a maximum value of associated sales data of a target class, wherein the target class comprises other classes except the first M classes in which the sales data are arranged from high to low in each class of the historical flight, and M=N-1;
for other cabin classes except the target cabin class, judging whether the associated sales data of the other cabin classes is larger than the maximum value of the associated sales data of the target cabin class, and whether the associated sales data of the other cabin classes is larger than the associated sales data of the cabin class with the highest sales data in the cabin classes of the historical flights;
if the associated sales data of other cabin levels are judged to be larger than the maximum value of the associated sales data of the target cabin level, and the associated sales data of other cabin levels are larger than the associated sales data of cabin levels with highest sales data in each cabin level of the historical flights, the sales data of N cabin levels corresponding to the associated sales data of other cabin levels are all jump cabin sales data, and it is determined that flights containing jump cabin sales data in the historical flights are abnormal flights.
In one embodiment of the present application, based on the foregoing, the first processing unit 502 is configured to, when determining, for the other cabin classes except the target cabin class, whether the associated sales data of the other cabin classes is greater than the maximum value of the associated sales data of the target cabin class, and whether the associated sales data of the other cabin classes is greater than the associated sales data of the cabin class with the highest sales data among the cabin classes of the historical flights:
for flights with passenger seat rate higher than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of other cabin classes are larger than the associated sales data of the cabin class with highest sales data in the cabin classes of the historical flights or not for other cabin classes before the cabin class corresponding to the maximum value of the associated sales data of the target cabin class;
for flights with passenger seat rates lower than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class for other cabin classes after the cabin class corresponding to the maximum value of the associated sales data of the target cabin class, and whether the associated sales data of other cabin classes are larger than the associated sales data of the cabin class with the highest sales data in all cabin classes of historical flights.
In one embodiment of the present application, based on the foregoing scheme, the second obtaining unit 503 is specifically configured to:
acquiring a historical booking average value of an abnormal flight at each preset acquisition time point, carrying out invalidation judgment on each historical booking average value, and carrying out data correction on the invalid historical booking average value;
and obtaining reservation data of the abnormal flight based on the historical reservation average value after the data correction and the historical reservation average value determined to be the effective value.
In one embodiment of the present application, based on the foregoing scheme, the second processing unit 504 is specifically configured to:
obtaining the sum of the booking numbers of the cabin levels corresponding to the cabin jump sales data in the abnormal flight according to the booking data of the abnormal flight;
obtaining the sum of the jump cabin sales data of the abnormal flights according to the jump cabin sales data of the abnormal flights;
obtaining sales data of average booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flights according to the sum of cabin jump sales data of the abnormal flights and the sum of booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flights;
and obtaining processed sales data according to the sales data of the average booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight and the booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight.
The units involved in the embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. The name of the unit is not limited to the unit itself in some cases, and for example, the first acquisition unit may also be described as "a unit that acquires sales data of historical flights".
Example III
Fig. 6 is a schematic diagram of an electronic device according to an embodiment of the present application.
Referring to fig. 6, a schematic diagram of an electronic device suitable for use in implementing embodiments of the present application is shown. The electronic device in the embodiment of the present application may include, but is not limited to, a fixed terminal such as a mobile phone, a notebook computer, a PDA (personal digital assistant), a PAD (tablet computer), a desktop computer, and the like. The electronic device shown in fig. 6 is only an example and should not be construed as limiting the functionality and scope of use of the embodiments of the application.
As shown in fig. 6, the electronic device may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 601, which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage means 608 into a Random Access Memory (RAM) 603. In the state where the electronic device is powered on, various programs and data necessary for the operation of the electronic device are also stored in the RAM 603. The processing device 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
In general, the following devices may be connected to the I/O interface 605: input devices 606 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, and the like; an output device 607 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 608 including, for example, memory cards, hard disks, etc.; and a communication device 609. The communication means 609 may allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. While fig. 6 shows an electronic device having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
It should be noted that the computer readable medium described in the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present disclosure, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
In the detailed description, the application will be repeated with all matters protected by the claims in the form of the following description:
in accordance with one or more embodiments of the present disclosure, fig. 1 provides a method for processing sales data of historical flights, including: acquiring sales data of historical flights; determining abnormal flights of the jump cabin sales data in the sales data of the historical flights; acquiring historical seat booking data of the abnormal flight; and processing the cabin-jump sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data.
FIG. 2 provides a process for determining flight sales data in a method for processing sales data for historical flights, according to one or more embodiments of the present disclosure, including: acquiring sales data of each cabin level of the historical flight; determining any adjacent N cabin classes in each cabin class of the historical flight as the associated cabin class of the first cabin class in the N cabin classes, and determining the sum of sales data of the N cabin classes as the associated sales data of the first cabin class in the N cabin classes; determining a maximum value of associated sales data for a target class, the target class comprising other classes of the historical flights than the first M classes arranged from high to low in sales data, wherein M = N-1; judging whether the associated sales data of other cabin classes is larger than the maximum value of the associated sales data of the target cabin class aiming at the other cabin classes except the target cabin class, and whether the associated sales data of the other cabin classes is larger than the associated sales data of the cabin class with the highest sales data in the cabin classes of the historical flight; if the associated sales data of the other cabin levels are larger than the maximum value of the associated sales data of the target cabin level and the associated sales data of the other cabin levels are larger than the associated sales data of the cabin level with the highest sales data in each cabin level of the historical flights, the sales data of the N cabin levels corresponding to the associated sales data of the other cabin levels are all cabin-jump sales data, and the flights containing the cabin-jump sales data in the historical flights are determined to be abnormal flights.
Wherein the determining, for the other cabin classes except the target cabin class, whether the associated sales data of the other cabin classes is greater than the maximum value of the associated sales data of the target cabin class, and whether the associated sales data of the other cabin classes is greater than the associated sales data of the cabin class with the highest sales data among the cabin classes of the historical flight, includes: for flights with passenger seat rate higher than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of the other cabin classes are larger than the associated sales data of the cabin class with highest sales data in the cabin classes of the historical flights or not for other cabin classes before the cabin class corresponding to the maximum value of the associated sales data of the target cabin class; for flights with passenger seat rates lower than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of the other cabin classes are larger than the associated sales data of the cabin class with the highest sales data in the cabin classes of the historical flights or not for other cabin classes after the cabin class corresponding to the maximum value of the associated sales data of the target cabin class.
FIG. 3 provides a process for obtaining historical seat reservation data for an anomalous flight in a method for processing sales data for a historical flight, including: acquiring a historical booking average value of the abnormal flight at each preset acquisition time point, carrying out invalidation judgment on each historical booking average value, and carrying out data correction on the invalid historical booking average value; and obtaining the booking data of the abnormal flight based on the historical booking average value after data correction and the historical booking average value determined to be the effective value.
Fig. 4 provides a process for processing jump cabin sales data in a method for processing sales data of historical flights, according to one or more embodiments of the present disclosure, including: obtaining the sum of the booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight according to the booking data of the abnormal flight; obtaining the sum of the jump cabin sales data of the abnormal flight according to the jump cabin sales data of the abnormal flight; obtaining sales data of average booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight according to the sum of cabin jump sales data of the abnormal flight and the sum of booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight; and obtaining processed sales data according to the sales data of the average booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight and the booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight.
FIG. 5 provides a processing apparatus for sales data for historical flights, according to one or more embodiments of the present disclosure, comprising: a first acquisition unit configured to acquire sales data of a historical flight; the first processing unit is used for determining abnormal flights with jump cabin sales data in the sales data of the historical flights; the second acquisition unit is used for acquiring historical seat booking data of the abnormal flight; and the second processing unit is used for processing the jump cabin sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are example forms of implementing the claims.
While several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.
The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being employed. It will be appreciated by persons skilled in the art that the scope of the disclosure referred to in this disclosure is not limited to the specific combinations of features described above, but also covers other embodiments which may be formed by any combination of features described above or equivalents thereof without departing from the spirit of the disclosure. Such as those described above, are mutually substituted with the technical features having similar functions disclosed in the present disclosure (but not limited thereto).

Claims (6)

1. A method for processing sales data of a historic flight, comprising:
acquiring sales data of historical flights;
determining abnormal flights of the jump cabin sales data in the sales data of the historical flights;
acquiring historical seat booking data of the abnormal flight;
processing the cabin-jump sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data;
wherein, determining that abnormal flights of the skip cabin sales data exist in the sales data of the historical flights includes:
acquiring sales data of each cabin level of the historical flight;
Determining any adjacent N cabin classes in each cabin class of the historical flight as the associated cabin class of the first cabin class in the N cabin classes, and determining the sum of sales data of the N cabin classes as the associated sales data of the first cabin class in the N cabin classes;
determining a maximum value of associated sales data for a target class, the target class comprising other classes of the historical flights than the first M classes arranged from high to low in sales data, wherein M = N-1;
for each class of the historical flight, other classes of the target class are removed, whether the associated sales data of the other classes are larger than the maximum value of the associated sales data of the target class is judged, and whether the associated sales data of the other classes are larger than the associated sales data of the class with the highest sales data in each class of the historical flight is judged;
if the associated sales data of the other cabin levels are judged to be larger than the maximum value of the associated sales data of the target cabin level, and the associated sales data of the other cabin levels are larger than the associated sales data of the cabin level with the highest sales data in each cabin level of the historical flights, the sales data of N cabin levels corresponding to the associated sales data of the other cabin levels are all cabin-jump sales data, and the flights containing the cabin-jump sales data in the historical flights are determined to be abnormal flights;
The step of determining whether the associated sales data of the other cabin classes is greater than the maximum value of the associated sales data of the target cabin class, and whether the associated sales data of the other cabin classes is greater than the associated sales data of the cabin class with the highest sales data among the cabin classes of the historical flight, includes:
for flights with passenger seat rate higher than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of the other cabin classes are larger than the associated sales data of the cabin class with highest sales data in the cabin classes of the historical flights or not for other cabin classes before the cabin class corresponding to the maximum value of the associated sales data of the target cabin class;
for flights with passenger seat rates lower than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of the other cabin classes are larger than the associated sales data of the cabin class with the highest sales data in the cabin classes of the historical flights or not for other cabin classes after the cabin class corresponding to the maximum value of the associated sales data of the target cabin class;
The step of processing the cabin-jump sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data comprises the following steps:
obtaining the sum of the booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight according to the booking data of the abnormal flight;
obtaining the sum of the jump cabin sales data of the abnormal flight according to the jump cabin sales data of the abnormal flight;
according to the sum of the cabin-jump sales data of the abnormal flights and the sum of the cabin-level reservation numbers corresponding to the cabin-jump sales data in the abnormal flights, the sales data of the average cabin-level reservation numbers corresponding to the cabin-jump sales data in the abnormal flights can be obtained;
and obtaining processed sales data according to the sales data of the average booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight and the booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight.
2. The method for processing sales data of a historical flight according to claim 1, wherein the acquiring historical seat reservation data of the abnormal flight comprises:
acquiring a historical booking average value of the abnormal flight at each preset acquisition time point, carrying out invalidation judgment on each historical booking average value, and carrying out data correction on the invalid historical booking average value;
And obtaining the booking data of the abnormal flight based on the historical booking average value after data correction and the historical booking average value determined to be the effective value.
3. A device for processing sales data of a historic flight, comprising:
a first acquisition unit configured to acquire sales data of a historical flight;
the first processing unit is used for determining abnormal flights of the jump cabin sales data in the sales data of the historical flights;
the second acquisition unit is used for acquiring the historical seat booking data of the abnormal flight;
the second processing unit is used for processing the cabin-jump sales data according to the historical seat booking data of the abnormal flight to obtain processed sales data;
the first processing unit is specifically configured to:
acquiring sales data of each cabin level of the historical flight;
determining any adjacent N cabin classes in each cabin class of the historical flight as the associated cabin class of the first cabin class in the N cabin classes, and determining the sum of sales data of the N cabin classes as the associated sales data of the first cabin class in the N cabin classes;
determining a maximum value of associated sales data for a target class, the target class comprising other classes of the historical flights than the first M classes arranged from high to low in sales data, wherein M = N-1;
For each class of the historical flight, other classes of the target class are removed, whether the associated sales data of the other classes are larger than the maximum value of the associated sales data of the target class is judged, and whether the associated sales data of the other classes are larger than the associated sales data of the class with the highest sales data in each class of the historical flight is judged;
if the associated sales data of the other cabin levels are judged to be larger than the maximum value of the associated sales data of the target cabin level, and the associated sales data of the other cabin levels are larger than the associated sales data of the cabin level with the highest sales data in each cabin level of the historical flights, the sales data of N cabin levels corresponding to the associated sales data of the other cabin levels are all cabin-jump sales data, and the flights containing the cabin-jump sales data in the historical flights are determined to be abnormal flights;
the method comprises the steps that other cabin levels of the target cabin level are removed from each cabin level of the historical flight, whether the associated sales data of the other cabin levels are larger than the maximum value of the associated sales data of the target cabin level is judged, and whether the associated sales data of the other cabin levels are larger than the associated sales data of the cabin level with the highest sales data in each cabin level of the historical flight is specifically used for:
For flights with passenger seat rate higher than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of the other cabin classes are larger than the associated sales data of the cabin class with highest sales data in the cabin classes of the historical flights or not for other cabin classes before the cabin class corresponding to the maximum value of the associated sales data of the target cabin class;
for flights with passenger seat rates lower than a set threshold range, judging whether the associated sales data of other cabin classes are larger than the maximum value of the associated sales data of the target cabin class or not and whether the associated sales data of the other cabin classes are larger than the associated sales data of the cabin class with the highest sales data in the cabin classes of the historical flights or not for other cabin classes after the cabin class corresponding to the maximum value of the associated sales data of the target cabin class;
wherein the second processing unit is specifically configured to:
obtaining the sum of the booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight according to the booking data of the abnormal flight;
obtaining the sum of the jump cabin sales data of the abnormal flight according to the jump cabin sales data of the abnormal flight;
Obtaining sales data of average booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight according to the sum of cabin jump sales data of the abnormal flight and the sum of booking numbers of cabin levels corresponding to the cabin jump sales data in the abnormal flight;
and obtaining processed sales data according to the sales data of the average booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight and the booking number of the cabin class corresponding to the cabin-jump sales data in the abnormal flight.
4. A device for processing sales data of historical flights according to claim 3, wherein the second acquisition unit is specifically configured to:
acquiring a historical booking average value of the abnormal flight at each preset acquisition time point, carrying out invalidation judgment on each historical booking average value, and carrying out data correction on the invalid historical booking average value;
and obtaining the booking data of the abnormal flight based on the historical booking average value after data correction and the historical booking average value determined to be the effective value.
5. An electronic device comprising at least one processor and a memory coupled to the processor, wherein:
The memory is used for storing a computer program;
the processor is configured to execute the computer program to enable the electronic device to implement the method of processing sales data of a historical flight as claimed in any one of claims 1 to 2.
6. A computer storage medium carrying one or more computer programs which, when executed by an electronic device, enable the electronic device to implement a method of processing sales data for a historical flight as claimed in any one of claims 1 to 2.
CN202311034903.7A 2023-08-16 2023-08-16 Method and related device for processing sales data of historical flights Active CN116757728B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311034903.7A CN116757728B (en) 2023-08-16 2023-08-16 Method and related device for processing sales data of historical flights

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311034903.7A CN116757728B (en) 2023-08-16 2023-08-16 Method and related device for processing sales data of historical flights

Publications (2)

Publication Number Publication Date
CN116757728A CN116757728A (en) 2023-09-15
CN116757728B true CN116757728B (en) 2023-10-24

Family

ID=87948155

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311034903.7A Active CN116757728B (en) 2023-08-16 2023-08-16 Method and related device for processing sales data of historical flights

Country Status (1)

Country Link
CN (1) CN116757728B (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111191710A (en) * 2019-12-26 2020-05-22 广州优策科技有限公司 Abnormal flight identification method based on big data
CN111192090A (en) * 2019-12-31 2020-05-22 广州优策科技有限公司 Seat allocation method and device for flight, storage medium and electronic equipment
CN113313393A (en) * 2021-06-01 2021-08-27 中国民航信息网络股份有限公司 Processing method, device, readable medium and equipment for flight space control instruction
CN114491385A (en) * 2022-01-21 2022-05-13 中国民航信息网络股份有限公司 Cabin adjusting method and device
CN115168456A (en) * 2022-09-07 2022-10-11 中国民航信息网络股份有限公司 Flight sales process feature acquisition method and device, storage medium and electronic equipment

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP5982066B1 (en) * 2015-08-07 2016-08-31 株式会社野村総合研究所 Air ticket sales system

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111191710A (en) * 2019-12-26 2020-05-22 广州优策科技有限公司 Abnormal flight identification method based on big data
CN111192090A (en) * 2019-12-31 2020-05-22 广州优策科技有限公司 Seat allocation method and device for flight, storage medium and electronic equipment
CN113313393A (en) * 2021-06-01 2021-08-27 中国民航信息网络股份有限公司 Processing method, device, readable medium and equipment for flight space control instruction
CN114491385A (en) * 2022-01-21 2022-05-13 中国民航信息网络股份有限公司 Cabin adjusting method and device
WO2023137898A1 (en) * 2022-01-21 2023-07-27 中国民航信息网络股份有限公司 Cabin adjustment method and device
CN115168456A (en) * 2022-09-07 2022-10-11 中国民航信息网络股份有限公司 Flight sales process feature acquisition method and device, storage medium and electronic equipment

Also Published As

Publication number Publication date
CN116757728A (en) 2023-09-15

Similar Documents

Publication Publication Date Title
CN111738316B (en) Zero sample learning image classification method and device and electronic equipment
CN113722056A (en) Task scheduling method and device, electronic equipment and computer readable medium
CN113159453B (en) Resource data prediction method, device, equipment and storage medium
CN115357350A (en) Task configuration method and device, electronic equipment and computer readable medium
CN116757731B (en) Flight season factor prediction method and device, electronic equipment and storage medium
CN116757728B (en) Method and related device for processing sales data of historical flights
CN114185463A (en) Form processing method and device, electronic equipment and storage medium
CN111784295A (en) Flight validation method and device
CN117648167B (en) Resource scheduling method, device, equipment and storage medium
CN111694755B (en) Application program testing method and device, electronic equipment and medium
CN116820539B (en) System software operation maintenance system and method based on Internet
CN116541421B (en) Address query information generation method and device, electronic equipment and computer medium
CN111797932B (en) Image classification method, apparatus, device and computer readable medium
CN118096029B (en) Order aging analysis method, device, equipment and computer storage medium
CN115689444B (en) Logistics automatic monitoring method, device, equipment and medium based on historical cases
CN113419992B (en) File clearing configuration page display method and device, electronic equipment and medium
CN116340632A (en) Object recommendation method, device, medium and electronic equipment
CN116882671A (en) Flight cabin position adjusting method and device
CN117688913A (en) Data management method and device, readable medium and electronic equipment
CN117808554A (en) Method and related device for predicting open quantity of on-duty facilities
CN115983922A (en) Processing method for travel order change and related device
CN116362947A (en) Seat map refreshing method and device
CN118175056A (en) Communication network data checking method and device, electronic equipment and storage medium
CN116266087A (en) Icon click detection method, device, equipment and storage medium
CN117609250A (en) Passenger order record number generation method and related device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant