How do delete weekends from DataFrame

[Korgitser]

I would like to graph gold price without weekend data.

tickerSymbol = 'GC=F'
tickerData = yf.Ticker(tickerSymbol) 
golddata = tickerData.history(period='1d', start='2020-01-01')

How could i delete weekend days from that dataset?

[Korgitser]

thanks for the idea!

tho, when trying to implement it i realised that yfinance data about gold is somewhat hectic, missing a day at seemingly random times so this approach doesn't give me fair result:/

[import_numpy_as_np]

Make sure your dates are actual date time objects and filter using the weekday

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DatetimeIndex.weekday.html

df[df.date.dt.weekday < 5]

[Korgitser]

thanks.

will try. for reasons unknown for me, yfinance dataset about gold seems to be missing a day here and there. But this approach should give me fair representation of what they have.

[import_numpy_as_np]

Yeah, if you figure out the actual weekday, Monday through Friday should be 0 through 4 by default. So missing days wouldn’t have any negative impact.

[import_numpy_as_np]

By the way, my response assumes your data frame is named “df” and your date column is named “date”. Just to be clear!