part_tracking

part_tracking ¤

Production tracking by part number.

Simple, practical module for daily production reporting: - How many parts were produced? - Production by part number and time window - Daily summaries

PartProductionTracking ¤

PartProductionTracking(
    dataframe: DataFrame, *, time_column: str = "systime"
)

Bases: Base

Track production quantities by part number.

Each UUID represents one signal: - part_id_uuid: string signal with current part number - counter_uuid: monotonic counter for production count

Example usage

tracker = PartProductionTracking(df)

Hourly production by part¤

hourly = tracker.production_by_part( part_id_uuid='part_number_signal', counter_uuid='counter_signal', window='1h' )

Daily summary¤

daily = tracker.daily_production_summary( part_id_uuid='part_number_signal', counter_uuid='counter_signal' )

Initialize part production tracker.

Parameters:

Name	Type	Description	Default
`dataframe`	`DataFrame`	Input DataFrame with timeseries data	required
`time_column`	`str`	Name of timestamp column (default: 'systime')	`'systime'`

production_by_part ¤

production_by_part(
    part_id_uuid: str,
    counter_uuid: str,
    *,
    window: str = "1h",
    value_column_part: str = "value_string",
    value_column_counter: str = "value_integer"
) -> pd.DataFrame

Calculate production quantity per part number.

Parameters:

Name	Type	Description	Default
`part_id_uuid`	`str`	UUID for part number signal	required
`counter_uuid`	`str`	UUID for production counter	required
`window`	`str`	Time window for aggregation (e.g., '1h', '8h', '1d')	`'1h'`
`value_column_part`	`str`	Column containing part numbers	`'value_string'`
`value_column_counter`	`str`	Column containing counter values	`'value_integer'`

Returns:

Type	Description
`DataFrame`	DataFrame with columns:
`DataFrame`	window_start: Start of time window
`DataFrame`	part_number: Part number/ID
`DataFrame`	quantity: Parts produced in window
`DataFrame`	first_count: Counter value at window start
`DataFrame`	last_count: Counter value at window end

Example

production_by_part('part_id', 'counter', window='1h') window_start part_number quantity first_count last_count 0 2024-01-01 08:00:00 PART_A 150 1000 1150 1 2024-01-01 09:00:00 PART_A 145 1150 1295 2 2024-01-01 10:00:00 PART_B 98 1295 1393

daily_production_summary ¤

daily_production_summary(
    part_id_uuid: str,
    counter_uuid: str,
    *,
    value_column_part: str = "value_string",
    value_column_counter: str = "value_integer"
) -> pd.DataFrame

Daily production summary by part number.

Parameters:

Name	Type	Description	Default
`part_id_uuid`	`str`	UUID for part number signal	required
`counter_uuid`	`str`	UUID for production counter	required
`value_column_part`	`str`	Column containing part numbers	`'value_string'`
`value_column_counter`	`str`	Column containing counter values	`'value_integer'`

Returns:

Type	Description
`DataFrame`	DataFrame with columns:
`DataFrame`	date: Production date
`DataFrame`	part_number: Part number/ID
`DataFrame`	total_quantity: Total parts produced that day
`DataFrame`	hours_active: Number of hours with production

Example

daily_production_summary('part_id', 'counter') date part_number total_quantity hours_active 0 2024-01-01 PART_A 1200 8 1 2024-01-01 PART_B 850 6 2 2024-01-02 PART_A 1150 8

production_totals ¤

production_totals(
    part_id_uuid: str,
    counter_uuid: str,
    *,
    start_date: Optional[str] = None,
    end_date: Optional[str] = None,
    value_column_part: str = "value_string",
    value_column_counter: str = "value_integer"
) -> pd.DataFrame

Total production by part number for a date range.

Parameters:

Name	Type	Description	Default
`part_id_uuid`	`str`	UUID for part number signal	required
`counter_uuid`	`str`	UUID for production counter	required
`start_date`	`Optional[str]`	Start date 'YYYY-MM-DD' (optional)	`None`
`end_date`	`Optional[str]`	End date 'YYYY-MM-DD' (optional)	`None`
`value_column_part`	`str`	Column containing part numbers	`'value_string'`
`value_column_counter`	`str`	Column containing counter values	`'value_integer'`

Returns:

Type	Description
`DataFrame`	DataFrame with total production per part

Example

production_totals('part_id', 'counter', ... start_date='2024-01-01', end_date='2024-01-07') part_number total_quantity days_produced 0 PART_A 8450 5 1 PART_B 6200 4