Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Worthless Erroneous Results from uploaded CSV file #62

Closed
M4x28 opened this issue Apr 13, 2024 · 1 comment
Closed

Worthless Erroneous Results from uploaded CSV file #62

M4x28 opened this issue Apr 13, 2024 · 1 comment

Comments

@M4x28
Copy link

M4x28 commented Apr 13, 2024

Associate version

1.3.0

Orange version

3.36.2

Expected behavior

Frequent Itemsets and Association Rules Analyses

Actual behavior

worthless erroneous results

Steps to reproduce the behavior
  1. Load data into CSV File Import
  2. Connect to Frequent Itemsets and try analysis
  3. Connect to Association Rules and try analysis
Additional info (worksheets, data, screenshots, ...)

Orange Schema
image
Frequent Itemsets
image
Association Rules
image
Data Table
image
CSV Data Pivot like Market Basket dataset
pivot.csv
CSV Data like Foofmart 2000 dataset
dataset.csv

@janezd
Copy link
Contributor

janezd commented Apr 21, 2024

Frequent Itemsets and Association Rules must be run on basket data. Open widget Datasets, find Foodmart and try it.

Data in attribute-value form (like the one that you use) must be used when we don't want to treat a "0" value as special. They find relations like "didn't buy bread -> didn't buy ham", and there are naturally many more of them. This is by design.

In your case, 0 is a special value, so the data must be given like this: https://file.biolab.si/datasets/foodmart.basket.

@janezd janezd closed this as completed Apr 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants