Data Analytics

Case studies

Dr Robert Batzinger
Instructor Emeritus

2022-08-15

Flights

  • (BKK) Suvarnabhumi Bangkok Int’l
  • (CNX) Chiang Mai Int’l
  • (DMK) Don Muang Int’l

Monthly Air Passenger Arrivals and Departure

Fat database

Airline Flight Status Departure Arrival
Thai AirAsia AIQ3428 A320 Scheduled (in 23 hours 52 minutes) (CNX) Chiang Mai Int’l Mon 12:00PM +07 (DMK) Don Muang Int’l (Old Bangkok Int’l) 01:10PM +07 Mon
Thai AirAsia AIQ3436 A320 Scheduled (in 23 hours 17 minutes) (CNX) Chiang Mai Int’l Mon 11:25AM +07 (DMK) Don Muang Int’l (Old Bangkok Int’l) 12:45PM +07 Mon
Nok Air NOK125 B738 Arrived / Gate Arrival (DMK) Don Muang Int’l (Old Bangkok Int’l) Sun 09:30AM +07 (CNX) Chiang Mai Int’l 10:40AM +07 Sun
Thai AirAsia AIQ3436 A320 En Route / On Time (DMK) Don Muang Int’l (Old Bangkok Int’l) Sun 11:25AM +07 (CNX) Chiang Mai Int’l 12:45PM +07 Sun

Normalized Dataset

Date,DepTime,Dep,ArrTime,Arr,Flight,Aircraft 
2023-10-06,10:15,CNX,11:36,BKK,THD103,A320
2023-10-05,09:13,CNX,10:37,BKK,THD103,A320
2023-10-04,09:13,CNX,10:32,BKK,THD103,A320
2023-10-03,09:13,CNX,10:35,BKK,THD103,A320
2023-10-02,09:13,CNX,10:27,BKK,THD103,A320
2023-10-01,09:21,CNX,10:39,BKK,THD103,A320
2023-09-30,09:08,CNX,10:24,BKK,THD103,A320
2023-09-29,09:14,CNX,10:40,BKK,THD103,A320
2023-09-28,09:19,CNX,10:37,BKK,THD103,A320
2023-09-27,09:18,CNX,10:35,BKK,THD103,A320
2023-09-26,09:13,CNX,10:26,BKK,THD103,A320
2023-09-25,09:11,CNX,10:27,BKK,THD103,A320

Variation

\[\hbox{What effect did the Covid pandemic have on air travel?}\] \[\hbox{}\]

Applications

London Bike Hires

Seasonally adjusted

        Jan    Feb     Mar     Apr     May     Jun     Jul     Aug     Sep
2010      0      0       0       0       0       0   12461  341203  540859
2011 403178 398292  556155  673639  722072  638717  708454  642440  684780
2012 494325 481826  818209  649473  926952  858805 1014174 1163171 1015145
2013 565589 516588  504611  658230  749934  813631  998755  904155  701724
2014 493870 522940  757864  805571  890709 1052573 1183182 1055206 1058684
2015 583663 549278  701384  838543  899969 1039768 1134816 1042932  903429
2016 586325 597641  664485  763308 1013666  963232 1188428 1158393 1053039
2017 638491 618550  819752  917716  992601 1098294 1131838  994199  934751
2018 645901 576425  604921  824737 1112686 1181642 1253102 1058181 1008201
2019 685798 698917  792272  890148 1006547 1006434 1152150 1053921  965581
2020 709673 641128  553648  591294 1121435 1158560 1170060 1153276 1137524
2021 409887 511046  748511  943760  921988 1183634 1168166 1111134 1220318
2022 748502 749898 1056720 1031077 1201054 1280180 1315801 1259932  800950
2023 571133 613325  630605  646899  821433  884730  808688  778336       0
         Oct    Nov    Dec    yrtot
2010  544412 456304 285574  2180813
2011  708802 597191 408729  7142449
2012  856866 726893 513444  9519283
2013  674154 514146 443942  8045459
2014  907998 715447 579853 10023897
2015  885375 684518 608164  9871839
2016  945143 711002 658975 10303637
2017  973682 792082 534088 10446044
2018  978290 738024 585430 10567540
2019  851999 729111 592077 10424955
2020  848233 760245 589091 10434167
2021 1110571 945047 667202 10941264
2022  864369 725556 471833 11505872
2023       0      0      0  5755149

Sentiment analysis: Positive

Adaptable, Adventurous, Amazing, Amiable, Beautiful, Becoming, Beloved, Blessed, Blissful, Brotherly, Calming, Captivating, Charming, Cherished, Comforting, Compelling, Considerable, Credible, Dapper, Darling, Delicious, Delightful, Dependable, Desirable, Dreamy, Durable, Elegant, Empowering, Enchanting, Endearing, Energising, Enjoyable, Enlightening, Exceptional, Fabulous, Fancy, Fantastic, Fashionable, Faultless, Fetching, Flourishing, Formidable, Fulfilling, Funny, Generous, Gifted, Glamorous, Gleaming, Glowing, Godly, Gracious, Gratifying, Happening, Harmonious, Heavenly, Honourable, Ideal, Important, Incredible, Indispensable, Indisputable, Influential, Inspiring, Interesting, Irresistible, Joyful, Jolly, Jovial, Kindly, Kingly, Leading, Legendary, Liberating, Likeable, Lordly, Lovable, Luscious, Luxurious, Magical, Majestic, Memorable, Mesmerizing, Mighty, Miraculous, Motivational, Nifty, Obliging, Optimal, Original, Out of this world, Outgoing, Palatable, Paramount, Peaceful, Peachy, Perfect, Phenomenal, Picturesque, Pleasant, Pleasing, Pleasurable, Positive, Powerful, Praiseworthy, Precious, Prestigious, Prizewinning, Promising, Quality, Radiant, Reasonable, Refreshing, Reliable, Respectable, Revolutionary, Rewarding, Rousing, Saintly, Salubrious, Satisfying, Scrumptious, Sensational, Sexy, Shiny, Showy, Smashing, Soothing, Sought-after, Spectacular, Spiffy, Stimulating, Striking, Stunning, Stupendous, Superb, Supreme, Swanky, Tasteful, Tasty, Terrific, Thrilling, Titillating, Tremendous, Trusty, Ultimate, Unbelievable, Uplifting, Useful, Valuable, Vibrant

Negative words

abysmal, adverse, alarming, angry, annoy, anxious, apathy, appalling, atrocious, awful, bad, banal, barbed, belligerent, bemoan, beneath, boring, broken, callous, can’t, clumsy, coarse, cold, cold-hearted, collapse, confused, contradictory, contrary, corrosive, corrupt, crazy, creepy, criminal, cruel, cry, cutting, damage, damaging, dastardly, dead, decaying, deformed, deny, deplorable, depressed, deprived, despicable, detrimental, dirty, disease, disgusting, disheveled, dishonest, dishonorable, dismal, distress, don’t, dreadful, dreary, enraged, eroding, evil, fail, faulty, fear, feeble, fight, filthy, foul, frighten, frightful, gawky, ghastly, grave, greed, grim, grimace, gross, grotesque, gruesome, guilty, haggard, hard, hard-hearted, harmful, hate, hideous, homely, horrendous, horrible, hostile, hurt, hurtful, icky, ignorant, ignore, ill, immature, imperfect, impossible, inane, inelegant, infernal, injure, injurious, insane, insidious, insipid, jealous, junky, lose, lousy, lumpy, malicious, mean, menacing, messy, misshapen, missing, misunderstood, moan, moldy, monstrous, naive, nasty, naughty, negate, negative, never, no, nobody, nondescript, nonsense, not, noxious, objectionable, odious, offensive, old, oppressive, pain, perturb, pessimistic, petty, plain, poisonous, poor, prejudice, questionable, quirky, quit, reject, renege, repellant, reptilian, repugnant, repulsive, revenge, revolting, rocky, rotten, rude, ruthless, sad, savage, scare, scary, scream, severe, shocking, shoddy, sick, , sickening, sinister, slimy, smelly, sobbing, sorry, spiteful, sticky, stinky, stormy, stressful, stuck, stupid, substandard, suspect, suspicious, tense, terrible, terrifying, threatening, ugly, undermine, unfair, unfavorable, unhappy, unhealthy, unjust, unlucky, unpleasant, unsatisfactory, unsightly, untoward, unwanted, unwelcome, unwholesome, unwieldy, unwise, upset, vicevicious, vile, villainous, vindictive, wary, weary, wicked, woeful, worthless, wound, yell, yucky, zero

Using Bayesian to rate words

Positive Messages

  1. Although I didn’t like Stanley & Iris tremendously as a film, I did admire the acting. Jane Fonda and Robert De Niro are great in this movie. I haven’t always been a fan of Fonda’s work but here she is delicate and strong at the same time. De Niro has the ability to make every role he portrays into acting gold. He gives a great performance in this film and there is a great scene where he has to take his father to a home for elderly people because he can’t care for him anymore that will break your heart. I wouldn’t really recommend this film as a great cinematic entertainment, but I will say you won’t see much better acting anywhere.

  2. This film has a special place in my heart, as when I caught it the first time, I was teaching adult literacy. It rang very true to me and even an outstanding student I had at the time. There are scenes which make you gulp with sudden emotion, and those which even put a smile on your face through sheer identification with the characters and their situation. Excellent performances by Jane Fonda and Robert DeNiro that rank with their best work, a great turn by a young Martha Plimpton, an inspiring story line, and a haunting musical score makes for a most enjoyable and rewarding experience.

  3. Very good drama although it appeared to have a few blank areas leaving the viewers to fill in the action for themselves. I can imagine life being this way for someone who can neither read nor write. This film simply smacked of the real world: the wife who is suddenly the sole supporter, the live-in relatives and their quarrels, the troubled child who gets knocked up and then, typically, drops out of school, a jackass husband who takes the nest egg and buys beer with it. 2 thumbs up.

Negative Message

  1. This film had a lot of promise, and the plot was relatively interesting, however the actors, director and editors seriously let this film down. I feel bad for the writers, it could have been good. The acting is wooden, very few of the characters are believable. Who ever edited this clearly just learnt some new edit techniques and wanted to splash them all over the film. There are lots of quick ‘flashy’ edits in almost every scene, which are clearly meant to be symbolic but just end up as annoying. I wanted to like this film and expected there to be a decent resolution to the breakdown of equilibrium but alas no, it left me feeling like I’d wasted my time and the film makers had wasted their money.

  2. Robert DeNiro plays the most unbelievably intelligent illiterate of all time. This movie is so wasteful of talent, it is truly disgusting. The script is unbelievable. The dialog is unbelievable. Jane Fonda’s character is a caricature of herself, and not a funny one. The movie moves at a snail’s pace, is photographed in an ill-advised manner, and is insufferably preachy. It also plugs in every cliche in the book. Swoozie Kurtz is excellent in a supporting role, but so what? Equally annoying is this new IMDB rule of requiring ten lines for every review. When a movie is this worthless, it doesn’t require ten lines of text to let other readers know that it is a waste of time and tape. Avoid this movie.

  3. This film had a lot of promise, and the plot was relatively interesting, however the actors, director and editors seriously let this film down. I feel bad for the writers, it could have been good. The acting is wooden, very few of the characters are believable. Who ever edited this clearly just learnt some new edit techniques and wanted to splash them all over the film. There are lots of quick ‘flashy’ edits in almost every scene, which are clearly meant to be symbolic but just end up as annoying. I wanted to like this film and expected there to be a decent resolution to the breakdown of equilibrium but alas no, it left me feeling like I’d wasted my time and the film makers had wasted their money.

Bayesian Test

Lookup of an individual target word like “really” in the training set

Review type Total reviews Reviews w Key Score
Negative Review 400 20 \(-1\times\frac{20}{65} = -0.308\)
Neutral Reviews 300 40 \(0\times\frac{40}{65} = 0.000\)
Positive Reviews 500 2 \(1\times\frac{2}{65} = 0.031\)
Total 1,200 65 \(\small-0.308 + 0.031 = -0.277\)