Hi,

I downloaded a dataset from UCI repositories named Bag of Words:
http://archive.ics.uci.edu/ml/machine-learning-databases/bag-of-words/readme.txt


The dataset is in a text file with the following structure:
---

docID1 wordID1 count
docID1 wordID2 count
docID1 wordID3 count
docID1 wordID4 count
...
docID2 wordID2 count
docID2 wordID5 count
docID2 wordID6 count
---

Where docIDx is an integer that identifies the document x; wordIDy is
an integer that identifies the word y ; and count is an integer with
the number of times that the wordIDy appears in the docIDx.


Example:

---

1 1 3
1 2 54
1 3 11
1 4 17
2 1 5
2 4 78
2 5 20
---

I would like to import the file into a matrix (not sparse) where:

the wordIDy would correspond to the column [,y]

the docIDx would correspond to the row [x,]

the value in [x,y] would be the count of wordIDy in the docIDx

So, for the previous example it would be like:


    [,1][,2][,3][,4][,5]

[1,]  3   54  11 17   0

[2,]  5    0   0 78  20


I don1t have a clue about how to do this.

Can someone please help me?

Thank you

Rui

	[[alternative HTML version deleted]]

