Guest User

Untitled

a guest
Jul 23rd, 2023
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. #!/usr/bin/python3.11
  2.  
  3. import pandas as pd
  4.  
  5. if __name__ == "__main__":
  6. successive_white_bars = (
  7. pd.read_csv("https://stooq.pl/q/d/l/?s=wig20&i=d")
  8. .assign(
  9. start_date=lambda df: pd.to_datetime(df["Data"]),
  10. white_bar=lambda df: df["Zamkniecie"] > df["Otwarcie"],
  11. )
  12. .assign(bucket=lambda df: (df["white_bar"].diff() != 0).cumsum())
  13. .query("start_date.dt.year >= 2000 & white_bar == 1")
  14. .assign(bars=lambda df: df.groupby("bucket")["white_bar"].transform("count"))
  15. .drop_duplicates("bucket", keep="first")
  16. .query("bars >= 8")
  17. .sort_values("start_date", ascending=False)
  18. .loc[:, ["start_date", "bars"]]
  19. )
  20. print(successive_white_bars.to_string(index=False))
Advertisement
Add Comment
Please, Sign In to add comment