CODEWITHSUNDEEP
pythonpandasloopsslice
Hristo Stoychev
Hristo Stoychev

Reputation: 535

Pandas DataFrame slicing with iteration

I would like to perform some action on sliced DataFrame with multiple slice indexes. The pattern is df.iloc[0:24] , df.iloc[24:48], df.iloc[48:72] and so on with step 24 as you get it. How I can iterate it without to set it manually every time. More like df.iloc[x:z] and each iteration x=0, z=24 and next iteration with 24 step, x will be 24 and z=48 and so on. Thanks in advance, Hristo.

Upvotes: 5

Views: 9295

Answers (2)

Akshay Salvi
Akshay Salvi

Reputation: 199

output it will give df with 

for i in range(0,len(df)):
  dfnew = df.iloc[i : i + 42]
  i = i + 1
  print(dfnew)

0 to 41 indices data 1 to 42 2 to 43 by skipping first entire row with limit 42 rows of data.

Upvotes: 1

cs95
cs95

Reputation: 402852

for loop iteration

for i in range(0, len(df), 24):
    slc = df.iloc[i : i + 24]

groupby

df.groupby(df.index // 24 * 24).apply(your_function)

Upvotes: 12

Related Questions