0
$\begingroup$

I have this dataset (just a sample):

product1,product2,product3
product1,product4
product1,product2
product4,product3,product1,product2

The products are grouped by transaction. I want to create some data visualization using this dataset but I don't any tool or any type of visualization that allows creating some visualization with this structure...

Anyone can suggest me an option?

Thanks!

I feel desperate because they can not find anything that suits this data structure

$\endgroup$
  • 1
    $\begingroup$ But what do you want this visualisation for? What are you trying to find out? A visualisation is an answer to a question, and you haven't told us the question. $\endgroup$ – Spacedman Oct 11 '16 at 19:49
  • $\begingroup$ @Spacedman I want to find the strenght like a heat-map or a grid chart...A visualization that allows me to conclude what the most frequently item purchase together...but with this strucuture I can't find any tool $\endgroup$ – SaCvP Oct 11 '16 at 21:49
  • $\begingroup$ a similar question was asked recently here, this would work for a not too large number of items $\endgroup$ – oW_ Oct 11 '16 at 23:20
  • $\begingroup$ How can a visualisation be any better than a sorted table of pair-wise occurrences? $\endgroup$ – Spacedman Oct 12 '16 at 7:13
  • $\begingroup$ @Spacedman Which type of tool/language did you recommend to produce that table? $\endgroup$ – SaCvP Oct 12 '16 at 8:12
1
$\begingroup$

Considering data stored in CSV format like below without headers you can use below R code to plot simple bar chart. It will plot occurrences of transactions grouped by unique transactions.

product1,product2,product3
product1,product4
product1,product2
product4,product3,product1,product2
product1,product2,product3
product1,product4
product1,product4

R Code -

transactions <- read.csv("filepath/transactions.csv", header = FALSE)
transactions$V1
plot(transactions$V1)

Bar Chart-

enter image description here

$\endgroup$
0
$\begingroup$

You can use plotly for making interactive visualization and charts. You can also give a try to Linkurious. Hope it helps. Cheers! :)

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.