How to create features columns based on values across diff columns
Hi I am trying to do one hot encoding in Orange in order to conduct market basket analysis.
Currently I have transaction data as follows in my CSV:
| C# | Items | ||
|---|---|---|---|
| C1 | Apple | Orange | |
| C2 | Baby Milk | Apple | Orange |
I would like to find out what are the steps that I can do to process the data in orange or other software such that I am able to get this state for my data
| C# | Apple | Orange | Baby Milk |
|---|---|---|---|
| C1 | 1 | 1 | 0 |
| C2 | 1 | 1 | 1 |
Currently when I try to preprocess the data in orange using "continous discrete variables - one feature per line" I get individual feature value columns.
It is not entirely straightforward, but you could concatenate your products with comma or semicolon, pass it to Corpus, apply tokenization based on your concatenation character (comma, semicolon) with a Regex, then use Bag of Words from the Text add-on. I have tried it with Associate add-on, and it seems to work.
- csv.reader() is separating values by individual character
- Read csv value in loop controller Jmeter
- How to delete columns in a CSV file?
- csv.Error: iterator should return strings, not bytes
- How to correctly read a CSV file while escaping delimiter comma placed within square brackets using Apache Spark and Scala?
- Parse a tab-delimited, multiline text into an array of associative arrays using predefined column names
- sqlite3 import csv with column and row separator
- Convert every two values in a comma-separated string into associative array elements
- How can I separate tokens when there are some null tokens
- Writing dictionary items in csv correct format
- Handling empty cells and using null in Examples from a CSV file
- How to concatenate text from multiple rows into a single text string in SQL Server
- Retrieve whole lyrics from URL
- Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
- read csv file delimited by file separator control character (FS/ASCII 28/UTF-8 0x1C) into duckdb using the CLI
- Efficiently filtering comma separated strings in pandas/dask
- How to parse a CSV file using PHP
- Sanitize a CSV string containing double quoted values
- error "no such file or directory" when reading in csv file in python
- how to make a function that check if the csv file is valid or not? (python)
- Techniques on how to export large CSV file with Symfony
- delete alternate lines in a csv file libreoffice calc
- Why is my record map overwriting other fields in csvhelper?
- Struct to CSV data as string without creating CSV file
- Some characters in CSV file are not read during PHP fgetcsv()
- How to split a comma-separated value to columns
- Is there a way to deserialize CSV to object, mapping by varied column names?
- SSISDB package errs out, says variable does not exist
- Django: How do I create a model dynamically?
- importing CSV file to mysql, there is in persian(utf-8) formate text