Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Simple pandas question
#5
This is a good solution...

import pandas as pd
import numpy as np

# Import data
data = pd.read_excel('moving_average.xlsx', index_col=0, header=0)

results = []
for i in range(100):
    tmp = data.rolling(i+1, center=False, axis=0).mean()
    results.append(tmp)

df=pd.concat(results, axis=1)

df.to_excel("output.xlsx")
Reply


Messages In This Thread
Simple pandas question - by mcva - Nov-25-2021, 12:26 PM
RE: Simple pandas question - by jefsummers - Nov-30-2021, 03:13 AM
RE: Simple pandas question - by mcva - Nov-30-2021, 02:15 PM
RE: Simple pandas question - by jefsummers - Dec-05-2021, 01:51 PM
RE: Simple pandas question - by mcva - Dec-17-2021, 04:47 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  pandas df inside a df question mbaker_wv 4 1,266 Dec-25-2022, 01:11 AM
Last Post: mbaker_wv
  Pandas usecols question rsearing 1 1,312 Aug-20-2022, 10:10 PM
Last Post: jefsummers
  Simple question (I guess) tchadrack 1 1,377 Jan-08-2022, 06:36 AM
Last Post: buran
  Pandas question new2datasci 0 2,029 Jan-10-2021, 01:29 AM
Last Post: new2datasci
  Pandas merge question smw10c 2 5,834 Jul-02-2020, 06:56 PM
Last Post: hussainmujtaba
  Counting Criteria in Pandas Question Koenig 1 2,246 Sep-30-2019, 05:16 AM
Last Post: perfringo
  Simple String to Time within a pandas dataframe Ecniv 1 2,585 Jun-14-2019, 03:25 AM
Last Post: scidam
  Function question using Pandas smw10c 7 7,286 Feb-12-2019, 06:52 PM
Last Post: Nathandsn
  Simple pandas dataframe question popohoma 1 3,631 Jan-03-2019, 05:00 PM
Last Post: ashlardev
  question on pandas datareader kit12_31 3 9,381 Feb-05-2018, 11:55 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020