Icon

Joining Dates between

import pandasql as psimport pandas as pdsales_df=input_table_1period_df=input_table_2sql="select sales_df.[Sales Date], period_df.[Period] " \ + " from sales_df join period_df " \ + " on sales_df.[Sales Date] "\ + " between period_df.PeriodStart and period_df.PeriodEnd"output_table_1= ps.sqldf(sql, locals()) SalesPeriodsJoin between...using pandasql Table Creator Table Creator Python Script import pandasql as psimport pandas as pdsales_df=input_table_1period_df=input_table_2sql="select sales_df.[Sales Date], period_df.[Period] " \ + " from sales_df join period_df " \ + " on sales_df.[Sales Date] "\ + " between period_df.PeriodStart and period_df.PeriodEnd"output_table_1= ps.sqldf(sql, locals()) SalesPeriodsJoin between...using pandasql Table Creator Table Creator Python Script

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-05-27
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.3.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!