Eduardo
jupyter_client
; until that's fixed, you can dowgrade with: pip install 'jupyter_client<8'
Amardeep Singh
01/31/2023, 5:53 PMEduardo
Eduardo
Eduardo
Eduardo
cwd
to the execute_notebook
function to bring us one step closer to match papermill's API (for a drop-in replacement), plus, you can now export profiling data to CSV, thanks @Avi Vajpeyi for your contribution!Ido (Ploomber)
{{variable}}
format #137
• Adds support for newer versions of prettytable
• Drops support for old versions of IPython
• Adds %%config SqlMagic.autopolars = True
#138
• Shows missing driver package suggestion message #124
• Clearer error message on connection failure #120
• Adds tutorial on querying JSON data
• Adds `%jupysql`/`%%jupysql` as alias for `%sql`/`%%sql`
• Adds community link to ValueError
and TypeError
As always we’d love to get feedback, please let us know if anything’s missing and can make your life better!Eduardo
Ido (Ploomber)
Laura Gutierrez Funderburk
05/03/2023, 6:02 PMJess Mankewitz (they/she)
05/26/2023, 5:07 PMDwayne McMurchy
09/08/2023, 2:31 AMEduardo
Eduardo
Jochem
11/22/2023, 3:35 PMDwayne McMurchy
11/24/2023, 5:28 PM%sqlcmd explorer
Binder link is broken. Page reference: https://jupysql.ploomber.io/en/latest/user-guide/table_explorer.htmlDwayne McMurchy
11/26/2023, 3:00 AM%sql PIVOT Cities ON Year USING SUM(Population);
but using the DuckDB API does? Pivot duckdb example is from here.
ThxDwayne McMurchy
11/30/2023, 5:26 PMLaura Gutierrez Funderburk
12/01/2023, 5:09 PMEduardo
Butho Moyo
01/25/2024, 5:45 AMCY = Max(myCalendar["FY"])
.
My fiscal year runs from July to June of the preceding year. In the table myCalendar, FY is defined as
FY = "FY" &
if('myCalendar'[Month_Num]<7,'myCalendar'[Year]-1 &"-"& 'myCalendar'[Year],'myCalendar'[Year] &"-"& 'myCalendar'[Year]+1)
This gives me a text output, for example,FY2023-2024
and that is exactly what I want.
However, I am trying to define a measure, LY, that gives me the last fiscal year, for example,FY2022-2023
. I tried using the sameperiodlastyear function, but it didn't work. Any ideas would be appreciated.Laura Gutierrez Funderburk
01/30/2024, 12:52 AMLaura Gutierrez Funderburk
01/31/2024, 6:01 PMLaura Gutierrez Funderburk
02/05/2024, 10:23 PMLaura Gutierrez Funderburk
02/05/2024, 10:28 PMLaura Gutierrez Funderburk
02/12/2024, 7:07 AMLaura Gutierrez Funderburk
02/12/2024, 7:28 AMMarcelo Ramires
03/26/2024, 1:37 AM