Question: What is wrong with my Python code? I want it to search 2 columns BIT_return and TSX_return where it is

What is wrong with my Python code?

I want it to search 2 columns "BIT_return" and "TSX_return" where it is <=-0.02, in the excel data file called "excel_data". I need to use loc function because I want to compute the percentage of change.

CODE:

CaseA = excel_data[ 'BIT_return', 'TSX_return' ].loc [ ( excel_data [ ' BIT_return ',' TSX_return' ] <=-0.02 ) ] excel_data['Return_A']=excel_data['CaseA'].pct_change()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

I am working on python functions and a double dice roll game. I just wanted to know what's wrong with my python code and what I can improve on. Sample of question: Write a program to simulate the...

PLEASE HELP. ITS URGENT. CAN BE SUBMITTED TILL TM MORNING. no eval nor import can be used!!!!! python code i want whats exactly mentioned in the asighnment if i get something wrong i wont evaluate...

python progrmming task 3 and 4 Task 3: Practice How to Use String Object a) What is wrong with the following code? Explain verbally. el sl"Canada" s1 [2] = 'P'+' Computing Science 120.s10 Page 3 of...

What is wrong with my Python code? 4.10 LAB: Prediction with Logistic Regression The file Invistico Airitise,LR. Csv contains information from an aitine using the atias invistico Artine on custorner...

Can someone help me with my python code? I want to make it so it automatically assigns a new account ID when the user adds a new account. As you can see its not counting right and it is stuck at...

Introduction Note: Circular Buffers are described in Section 5.2.4 of our textbook (p. 211). Please read that section before proceeding. An interesting, relatively straightforward data structure is...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

In this problem, you will need to create a class named Board that implements some of the features of the Connect Four game. The Board class will have three instance variables: there will be a...

RMIT UNIVERSITY Programming Fundamentals (COSC2531) Assignment 2 Individual assignment (no group work). Submit online via Canvas/Assignments/Assignment 2. Marks are awarded per rubric (please see the...

Q:Write Python code that reads text from a provided file, searches for a specific word in the text, and returns the position ( line number ) of the first occurrence of this word. Instructions: 1 ....

The Pampas Bank of Argentina is worried about a very large fall in interest rates (around 8%). The bank is financed by a long-term fixed coupon bond and makes very short-term commercial loans. The...

What is a growth firms?

An internal auditor is assigned to audit an IT system but lacks the technical knowledge required. Based on Standard 3.1 Competency, what should the auditor do, and how should the CAE ensure the...

Please read the Opening Case: Organizing for Innovation: How Apple Organizes for Innovation (Page 225) in Strategic Management of Technological Innovation 7th edition. Explain the structural...

Develop successful mentoring programs. page 418

List the major elements that contribute to perceptions of justice and how to apply these in organizational contexts involving discipline and dismissal. page 445

Relate how assessment of personality type, work behaviors, and job performance can be used for employee development. page 406