Chrome File Edit View History Bookmarks People Window Help E 97% C Tue 11:46 PM

Question

Chrome File Edit View History Bookmarks People Window Help E 97% C Tue 11:46 PM Q E HCT Portal :. Practical-Exam-2-1 (anon-jzit ? y D e Computer Science question | Secure l https://practicalexam21-anon-jz?baw.notebooks.azure.com/nb/notebooks/H00325599_Abdalla%20Ali%20Ahmed.ipynb H00325599 Abdalla Ali Ahme x ,, x C Azure Notebooks My Libraries Testa-Version-265-9-7340d1) Not Trusted , I Python 3.6 C jupyter H00325599_Abdalla Ali Ahmed (autosaved) File Edit Vioew Insert Cll Kernel Data WidgetsHelp +9?4???_ Run. ?» Markdown #?? Enter/Exit RISE Slideshow Task-9 Use a suitable command to show the maximum value stored in the 'User Votes' column (1 Mark) In Task-10 Use a suitable command to show the minimum value stored in the 'User Votes' column (1 Mark) In : Task-11 In the data frame Films, create a calculated column named 'Profit' that will store the difference between the "Earnings

Explanation / Answer

As we assume the data is already in dataframe, and since the data is not shared so we will assume it is already in datafram format.

Ans 1) So to find the maximum value stored in 'User Votes' we will use below command:

df['User Votes'].max()

where df is the dataframe where our values are stored.

Ans 2) So to find the minimum value stored in 'User Votes' we will use below command:

df['User Votes'].min()

where df is the dataframe where our values are stored.

Ans 3) To create a new column named `Profit` and store difference of `Earning` & `Budget` below is the code:

df['Profit'] = df['Earning'] - df['Budget']

where df is the dataframe where our values are stored.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.