Untitled notebook

Mix.install([
  {:kino_explorer, "~> 0.1.11"},
  {:unzip, "~> 0.9.0"}
])

Section

require Explorer.DataFrame, as: DF

[customers, orders, orders_items, products] =
  for type <- [:customers, :orders, :orders_items, :products] do
    "/home/kuku/5784/noahs-#{type}.csv"
    |> DF.from_csv!()
  end

co =
  products
  |> DF.filter(contains(desc, "Rug Cleaner"))
  |> DF.join(orders_items)
  |> DF.join(orders)
  |> DF.filter(contains(ordered, "2017"))
  |> DF.join(customers)
  |> DF.filter(contains(name, "J") and contains(name, "P"))
  |> then(& &1[:phone])
  |> Explorer.Series.first()

cancer_start = "06-21"
cancer_end = "06-23"
# we need only the  year from third column
rabbit =
  """
  29 January 1903 	15 February 1904 	Water Hare
  14 February 1915 	3 February 1916 	Wood Hare
  2 February 1927 	22 January 1928 	Fire Hare
  19 February 1939 	7 February 1940 	Earth Hare
  6 February 1951 	26 January 1952 	Metal Hare
  25 January 1963 	12 February 1964 	Water Hare
  11 February 1975 	30 January 1976 	Wood Hare
  29 January 1987 	16 February 1988 	Fire Hare
  16 February 1999 	4 February 2000 	Earth Hare
  3 February 2011 	22 January 2012 	Metal Hare
  22 January 2023 	9 February 2024 	Water Hare 
  """
  |> String.split("\n", trim: true)
  |> Enum.map(fn line ->
    line
    |> String.split(" ", trim: true)
    |> Enum.at(2)
  end)
  |> Enum.map(fn year ->
    "#{year}-#{cancer_start},#{year}-#{cancer_end}"
  end)
  |> Enum.join("\n")
  |> DF.load_csv!()