Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python3.11
- import pandas as pd
- if __name__ == "__main__":
- successive_white_bars = (
- pd.read_csv("https://stooq.pl/q/d/l/?s=wig20&i=d")
- .assign(
- start_date=lambda df: pd.to_datetime(df["Data"]),
- white_bar=lambda df: df["Zamkniecie"] > df["Otwarcie"],
- )
- .assign(bucket=lambda df: (df["white_bar"].diff() != 0).cumsum())
- .query("start_date.dt.year >= 2000 & white_bar == 1")
- .assign(bars=lambda df: df.groupby("bucket")["white_bar"].transform("count"))
- .drop_duplicates("bucket", keep="first")
- .query("bars >= 8")
- .sort_values("start_date", ascending=False)
- .loc[:, ["start_date", "bars"]]
- )
- print(successive_white_bars.to_string(index=False))
Advertisement
Add Comment
Please, Sign In to add comment