My Problems:

Problem$1$:

My problem is$,$ If I convert Origin and Destination as numeric all the values become NaN and I am getting error as below:

IndexError$$ Traceback $($most recent call last$)$

Cell In$[186],$ line $124$

$122$ for route in recommended$\_$routes.itertuples$($index$=$False$)$:

$123$ origin, dest $=$ route

$-->124$ revenue $=$ revenue$\_$per$\_$route$[($revenue$\_$per$\_$route$[\text{'}$ORIGIN$\text{'}]==$ origin$)$ & $($revenue$\_$per$\_$route$[\text{'}$DESTINATION$\text{'}]==$ dest$)][\text{'}$TotalRevenue$\text{'}].$values$[0]$

$125$ cost $=$ cost$\_$per$\_$route$[($revenue$\_$per$\_$route$[\text{'}$ORIGIN$\text{'}]==$ origin$)$ & $($revenue$\_$per$\_$route$[\text{'}$DESTINATION$\text{'}]==$ dest$)]$

$126$ breakeven$\_$point $=$ upfront$\_$airplane$\_$cost $/($revenue $-$ cost$)$ if revenue $>$ cost else float$(\text{'}$inf$\text{'})$

IndexError: index $0$ is out of bounds for axis $0$ with size $0$

Problem $2$:

But if I don$$t convert them into Numeric then I am getting the Error as

TypeError$$ Traceback $($most recent call last$)$

Cell In$[188],$ line $102$

$99$return total$\_$cost $*$ num$\_$round$\_$trips

$101$ # Apply cost calculation and compute profitability

$-->102$ cost$\_$per$\_$route $=$ revenue$\_$per$\_$route.apply$($

$103$lambda x: calculate$\_$route$\_$cost$(($x$[\text{'}$ORIGIN$\text{'}],$ x$[\text{'}$DESTINATION$\text{'}]))$ if not pd$.$isna$($x$[\text{'}$ORIGIN$\text{'}])$ and not pd$.$isna$($x$[\text{'}$DESTINATION$\text{'}])$ else $0,$

$104$ axis$=1$

$105)$

$106$ profit$\_$per$\_$route $=$ revenue$\_$per$\_$route$[\text{'}$TotalRevenue$\text{'}]-$ cost$\_$per$\_$route

$108$ top$\_10\_$profitable$\_$routes $=$ pd$.$DataFrame$(\{$

$109\text{'}$Origin$\text{'}$: top$\_10\_$busiest$\_$routes$[\text{'}$ORIGIN$\text{'}],$

$110\text{'}$Dest$\text{'}$: top$\_10\_$busiest$\_$routes$[\text{'}$DESTINATION$\text{'}],$

$(...)$

$113\text{'}$Profit$\text{'}$: profit$\_$per$\_$route

$114\}).$nlargest$(10,$ 'Profit'$)$

File $/$Library$/$Frameworks$/$Python$.$framework$/$Versions$/3\mathrm{.}13/$lib$/$python$3\mathrm{.}13/$site$-$packages$/$pandas$/$core$/$frame$.$py:$10374,$ in DataFrame.apply$($self$,$ func, axis, raw, result$\_$type, args, by$\_$row, engine, engine$\_$kwargs, $**$kwargs$)$

$10360$ from pandas.core.apply import frame$\_$apply

$10362$ op $=$ frame$\_$apply$($

$10363$self$,$

$10364$ func$=$func,

$(...)$

$10372$ kwargs$=$kwargs,

$10373)$

$...$

$51$ def $\_$sum$($a$,$ axis$=$None, dtype$=$None, out$=$None, keepdims$=$False,

$52$ initial$=\_$NoValue, where$=$True$)$:

$--->53$return umr$\_$sum$($a$,$ axis, dtype, out, keepdims, initial, where$)$

TypeError: unsupported operand type$($s$)$ for $+$: 'float' and $\text{'}$str$\text{'}$

$----------------------------------------------$

I thought of using anther column Distance from flights csv file which gives the $$Distance between Origin and Destination Airports in Miles$$ but that has some data issues which I couldn$$t fix all of them

By default it is dtype$=$object $,$I couldn$$t convert it to numeric when I tried$$ I got following errors

Error $1$Couldn$$t convert string $$Hundred$$ to numeric$.$I fixed it by replacing it with number $100$

Error $2$Couldn$$t convert string $$Twenty$$ to numeric$.$ I fixed it by replacing it with number $20$

Error $3-$Couldn$$t convert string $2019-03-02$ to numeric$.$

When I tried to convert to numeric getting below error:

TypeError$$ Traceback $($most recent call last$)$

Cell In$[197],$ line $60$

$58$ filtered$\_$flights$\_$df$[\text{'}$DISTANCE$\text{'}].$fillna$(0)$

$59$ F$1=$filtered$\_$flights$\_$df$.$replace$(\{\text{'}$DISTANCE$\text{'}$:$\{\text{'}$Hundred$\text{'}$:$100,$ 'Twenty':$20,\text{'}0$H$0$u$0$n$0$d$0$r$0$e$0$d$0\text{'}$:$0,\text{'}\text{'}$:$0,\text{'}2019-03-02\text{'}$:$0,\text{'}****\text{'}$:$0\}\})$

$--->60$ F$1.$astype$(\text{'}$Int$\text{'})$

$62$ #roundtrip$\_$cost $=$ filtered$\_$flights$\_$df$.$groupby$([\text{'}$ORIGIN$\text{'},$ 'DESTINATION'$])[\text{'}$DISTANCE$\text{'}].$sum$().$reset$\_$index$($name$=$'Toipcost'$)$

$63$ print $($F$1)$

File $/$Library$/$Frameworks$/$Python$.$framework$/$Versions$/3\mathrm{.}13/$lib$/$python$3\mathrm{.}13/$site$-$packages$/$pandas$/$core$/$generic$.$py:$6643,$ in NDFrame.astype$($self$,$ dtype, copy, errors$)$

$6637$ results $=[$

$6638$ ser.astype$($dtype$,$ copy$=$copy, errors$=$errors$)$ for $\_,$ ser in self.items$()$

$6639]$

$6641$ else:

$6642$# else, only a single dtype is given

$->6643$ new$\_$data $=$ self.$\_$mgr$.$astype$($dtype$=$dtype, copy$=$copy, errors$=$errors$)$

$6644$ res $=$ self.$\_$constructor$\_$from$\_$mgr$($new$\_$data, axes$=$new$\_$data.axes$)$

$6645$return res.$\_\_$finalize$\_\_($self$,$ method$=$"astype"$)$

File $/$Library$/$Frameworks$/$Python$.$framework$/$Versions$/3\mathrm{.}13/$lib$/$python$3\mathrm{.}13/$site$-$packages$/$pandas$/$core$/$internals$/$managers$.$py:$430,$ in BaseBlockManager.astype$($self$,$ dtype, copy, errors$)$

$427$ elif using$\_$copy$\_$on$\_$write$()$:

$428$ copy $=$ False

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

7. Array-Oriented Programming with NumPy Objectives In this chapter, youll: Learn what arrays are and how they differ from lists. Use the numpy modules highperformance ndarrays. Compare list and...

Q:

The total number of points for this assignment is 120 points. Please submit your assignment in a Word file. Use this assignment file as a template to enter and copy-paste your answers for your...

Q:

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

Q:

Jupyter NoteBook Once we decide to measure more than three features per input vector, it can become challenging to understand how a network is learning to solve such a problem since we can no longer...

Q:

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

Q:

develop a memorandum addressed to the CFO that explains how you want to change your IT Department into a CIO organization and why. Your memo will address each of the topics listed below, and should...

Q:

(1) The Quality of Financial Information Referencing this week?s readings and lecture, describe the quality issues related to reporting revenue. What is the importance of understanding various...

Q:

read chapter 1 & 2 from the attashment book (the new international money game-7th), and then let me have a summary of them both within one or tow pages so i can solve the questions> 1 A System Is How...

Q:

Please write a program in Java with the following specs, Thank you very much The program The purpose of this assignment is to provide some exercise in using multiply-linked data structures. Your...

Q:

MUST USE C++: (c-strings) Implement a program that stuffs text from a plain text file into neatly arranged paragraphs with a particular maximum allowed line length. For example, if the desired...

Q:

Use the information presented in BE5-8 for Adams Company to prepare the long-term liabilities section of the balance sheet.

Q:

What accounts normally have debit balances? What accounts normally have credit balances?

Q:

CA6.4 (LO 2, 4) Writing (Basic Note and Accounts Receivable Transactions) Part 1: On July 1, 2025, Wallace Company, a calendar-year company, sold special-order merchandise on credit and received in...

Q:

Which if any of the following hypotheses represent a null hypothesis 59 76 29 65 90 16 Which if any of the following hypotheses represent an alternative hypothesis 16 76 29 0 90 D 59 65 Question Help...

Previous Question Next Question