CODEWITHSUNDEEP
pythonpandas
Joseph arasta
Joseph arasta

Reputation: 161

resample() got an unexpected keyword argument 'how'?

import pandas as pd
import os

files = os.listdir('D:\\Data\\200 Stocks 1 minute Data')
for file in files:
    df = pd.read_csv('D:\\Data\\200 Stocks 1 minute Data\\'+file)
    df['Date_time'] = df['Date'] + ' ' + df['Time']
    df['Date_time'] = pd.to_datetime(df['Date_time'])
    ohlc_dict = {
        'open':'first',
        'high':'max',
        'low':'min',
        'close':'last',
        'volume':'sum'
        }
    df.set_index('Date_time',inplace=True)
    df.resample('3min',how=ohlc_dict)
    pd.set_option('display.max_rows',2000)
    df.dropna(inplace=True)
    df.to_csv(file)

Here is my code. I have one minute data and I would like to convert it to 3 minutes. But I am getting this error. Type error - resample() got an unexpected keyword argument 'how'

Upvotes: 2

Views: 12200

Answers (2)

Palash Mondal
Palash Mondal

Reputation: 538

Few of the function from resample() has been deprecated. use format like- data_frame.resample('arg value').aggregate_function() For the above specific case use - df.resample('3min').agg(ohlc_dict)

Upvotes: 1

jezrael
jezrael

Reputation: 862851

Use GroupBy.agg with assign back, because not inplace operation:

df = df.resample('3min').agg(ohlc_dict)

Upvotes: 3

Related Questions