I am a Mtech student in Traffic and Transportation.My data base for project consist of huge amount of data (more than 10000).My topic is mode choice. There are five alternatives in the choice set for each individual.The coding for each alternatives are as follows.
Bus-1
Two wheeler-2
Car-3
Autorikshaw-4
Format of my sample data is shown in table 1 (excel sheet attached).The required format is shown in table 2.
Brief description
If a person is choosing autorikshaw(ID 4) for his travel and his person id is 1001,it should appear in the required format as 4 rows with person id 1001 and the corresponding choice should be enterd in the column as person id Choice
1001 0
1001 0
1001 0
1001 1
IN THE CHOICE COLUMN "1" SHOULD APPEAR AGAINST THE FOURTH ROW OF THE PERSON ID AS THE CODING FOR AUTO RIKSHAW IS 4
I hope you can help me in this matter.
Thanking you
Bookmarks