Styjun

Did Stalin kill all Soviet officers involved in the Winter War?

How serious is plagiarism in a master’s thesis?

Will electrically joined dipoles of different lengths, at right angles, behave as a multiband antenna?

how to convert Timestring to seconds

How to calculate a conditional PDF in mathematica?

Boss has banned cycling to work because he thinks it's unsafe

Did Snape really give Umbridge a fake Veritaserum potion that Harry later pretended to drink?

What are the differences of checking a self-signed certificate vs ignore it?

Why do Klingons use cloaking devices?

What instances can be solved today by modern solvers (pure LP)?

Milky way is orbiting around?

Why do we need a bootloader separate than our application program in MCU's?

Term for a character that only exists to be talked to

What units are kpts?

Convenience stores in India

How many spells does my Bard 6/Wizard 1 know?

How to figure out layers of the atmosphere?

About opening an LLC with little to report in the beginning

What is the difference between a historical drama and a period drama?

Motorcyle Chain needs to be cleaned every time you lube it?

Has chattel slavery ever been used as a criminal punishment in the USA since the passage of the Thirteenth Amendment?

Do the 26 richest billionaires own as much wealth as the poorest 3.8 billion people?

What is this arch-and-tower near a road?

How can solar sailed ships be protected from space debris?

Some calculations inside .rolling() give an IndexError

What is the Python equivalent of static variables inside a function?Rolling delinquiency calculation for a dataframeCalculation in CSV file with Python, Perl, CSVfix?How to get access to a column in a 2D list in Python?Resampling pandas dataframe is deleting columnHow to iterate over the rows of a csv file and drop based on the value of a particular columnGrouping columns in a Pandas Dataframeapply polyfit on rolling baseEfficient and salable way to Iterate over a Dataframe and write to text file row by row having huge amount of text dataCalculate pandas dataframe index difference based on the value of another column

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I don't know the exact value for .rolling(), so I need to calculate it based on the value of another column which is df.candle. So I would like to calculate index difference between current row and the row where df.candle = (df.candle[current_iteration] - 20)[0] (so 20 candles behind and first iteration (there are multiple rows with same candle value so [0])

So I though that something like this should work:

import pandas as pd

df = pd.read_csv('https://www.dropbox.com/s/hy94jp4d7qwmv04/eurusd_df1.csv?dl=1')
df.reset_index(inplace=True)

# pandas settings
pd.set_option('display.max_columns', 320)
pd.set_option('display.max_rows', 1320)
pd.set_option('display.width', 320)

#
a = df.index[df.candle == df.candle - 20][0]
df['test'] = df.bid.rolling(int(a)).mean()

But it actually gives an error:

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

So I'm a bit lost here...

EDIT: Here's, perhaps, a better and shorter explanation: https://www.reddit.com/r/learnpython/comments/b5o8o5/pandas_rolling_with_some_calculations_inside/

python pandas rolling-computation

share|improve this question

edited Mar 26 at 11:21

Andrey Kurnikovs

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please provide the full error traceback, and what happens when you print a?
  
  – G. Anderson
  Mar 25 at 19:12
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Also, a sample input and ideal ouput would help, see this link on creating a minimal reproducible example
  
  – G. Anderson
  Mar 25 at 19:13
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  df.candle == df.candle - 20 will return False, so you don't have anything for index.
  
  – bhansa
  Mar 25 at 19:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Traceback (most recent call last): File "C:/Users/irmsc/pp/fml/test.py", line 12, in <module> a = df.index[df.candle == df.candle - 20][0] File "C:Usersirmscppfmlvenvlibsite-packagespandascoreindexesbase.py", line 3957, in __getitem__ return getitem(key) IndexError: index 0 is out of bounds for axis 0 with size 0
  
  – Andrey Kurnikovs
  Mar 25 at 19:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Nothing happens when I print a, the traceback when calculating it.
  
  – Andrey Kurnikovs
  Mar 25 at 19:38
  

  
  
  
  

 | 
show 1 more comment

0

I don't know the exact value for .rolling(), so I need to calculate it based on the value of another column which is df.candle. So I would like to calculate index difference between current row and the row where df.candle = (df.candle[current_iteration] - 20)[0] (so 20 candles behind and first iteration (there are multiple rows with same candle value so [0])

So I though that something like this should work:

import pandas as pd

df = pd.read_csv('https://www.dropbox.com/s/hy94jp4d7qwmv04/eurusd_df1.csv?dl=1')
df.reset_index(inplace=True)

# pandas settings
pd.set_option('display.max_columns', 320)
pd.set_option('display.max_rows', 1320)
pd.set_option('display.width', 320)

#
a = df.index[df.candle == df.candle - 20][0]
df['test'] = df.bid.rolling(int(a)).mean()

But it actually gives an error:

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

So I'm a bit lost here...

EDIT: Here's, perhaps, a better and shorter explanation: https://www.reddit.com/r/learnpython/comments/b5o8o5/pandas_rolling_with_some_calculations_inside/

python pandas rolling-computation

share|improve this question

edited Mar 26 at 11:21

Andrey Kurnikovs

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please provide the full error traceback, and what happens when you print a?
  
  – G. Anderson
  Mar 25 at 19:12
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Also, a sample input and ideal ouput would help, see this link on creating a minimal reproducible example
  
  – G. Anderson
  Mar 25 at 19:13
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  df.candle == df.candle - 20 will return False, so you don't have anything for index.
  
  – bhansa
  Mar 25 at 19:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Traceback (most recent call last): File "C:/Users/irmsc/pp/fml/test.py", line 12, in <module> a = df.index[df.candle == df.candle - 20][0] File "C:Usersirmscppfmlvenvlibsite-packagespandascoreindexesbase.py", line 3957, in __getitem__ return getitem(key) IndexError: index 0 is out of bounds for axis 0 with size 0
  
  – Andrey Kurnikovs
  Mar 25 at 19:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Nothing happens when I print a, the traceback when calculating it.
  
  – Andrey Kurnikovs
  Mar 25 at 19:38
  

  
  
  
  

 | 
show 1 more comment

I don't know the exact value for .rolling(), so I need to calculate it based on the value of another column which is df.candle. So I would like to calculate index difference between current row and the row where df.candle = (df.candle[current_iteration] - 20)[0] (so 20 candles behind and first iteration (there are multiple rows with same candle value so [0])

So I though that something like this should work:

import pandas as pd

df = pd.read_csv('https://www.dropbox.com/s/hy94jp4d7qwmv04/eurusd_df1.csv?dl=1')
df.reset_index(inplace=True)

# pandas settings
pd.set_option('display.max_columns', 320)
pd.set_option('display.max_rows', 1320)
pd.set_option('display.width', 320)

#
a = df.index[df.candle == df.candle - 20][0]
df['test'] = df.bid.rolling(int(a)).mean()

But it actually gives an error:

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

So I'm a bit lost here...

EDIT: Here's, perhaps, a better and shorter explanation: https://www.reddit.com/r/learnpython/comments/b5o8o5/pandas_rolling_with_some_calculations_inside/

python pandas rolling-computation

share|improve this question

edited Mar 26 at 11:21

Andrey Kurnikovs

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges

import pandas as pd

df = pd.read_csv('https://www.dropbox.com/s/hy94jp4d7qwmv04/eurusd_df1.csv?dl=1')
df.reset_index(inplace=True)

# pandas settings
pd.set_option('display.max_columns', 320)
pd.set_option('display.max_rows', 1320)
pd.set_option('display.width', 320)

#
a = df.index[df.candle == df.candle - 20][0]
df['test'] = df.bid.rolling(int(a)).mean()

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

share|improve this question

edited Mar 26 at 11:21

Andrey Kurnikovs

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges

share|improve this question

edited Mar 26 at 11:21

Andrey Kurnikovs

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges

asked Mar 25 at 18:57

Andrey KurnikovsAndrey Kurnikovs

5211 silver badge1010 bronze badges