[R] How to process a log file in R ?
praveen pal
pal.praveen11 at gmail.com
Fri Jun 20 09:26:03 CEST 2014
Hello
i am new to R and need help,
I want to parse a log file using R named tracking.log file.
i try to read it using "jsonlite" package but not able to get data in
proper format.
i entered a sample of file below.
i also attached a file tracking.log file with this mail
{
"username": "lavita",
"host": "10.105.22.32",
"event_source": "server",
"event_type":
"/courses/IITB/CS101/2014_T1/xblock/i4x:;_;_IITB;_CS101;_video;_d333fa637a074b41996dc2fd5e675818/handler/xmodule_handler/save_user_state",
"context": {
"course_id": "IITB/CS101/2014_T1",
"course_user_tags": {},
"user_id": 42,
"org_id": "IITB"
},
"time": "2014-06-20T05:49:10.468638+00:00",
"ip": "127.0.0.1",
"event": "{\"POST\": {\"saved_video_position\": [\"00:02:10\"]},
\"GET\": {}}",
"agent": "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101
Firefox/18.0",
"page": null
}
{
"username": "raeha",
"host": "10.105.22.32",
"event_source": "server",
"event_type": "problem_check",
"context": {
"course_id": "IITB/CS101/2014_T1",
"course_user_tags": {},
"user_id": 40,
"org_id": "IITB",
"module": {
"display_name": ""
}
},
"time": "2014-06-20T06:43:52.716455+00:00",
"ip": "127.0.0.1",
"event": {
"submission": {
"i4x-IITB-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": {
"input_type": "choicegroup",
"question": "",
"response_type": "multiplechoiceresponse",
"answer": "MenuInflater.inflate()",
"variant": "",
"correct": true
}
},
"success": "correct",
"grade": 1,
"correct_map": {
"i4x-IITB-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": {
"hint": "",
"hintmode": null,
"correctness": "correct",
"npoints": null,
"msg": "",
"queuestate": null
}
},
"state": {
"student_answers": {},
"seed": 1,
"done": null,
"correct_map": {},
"input_state": {
"i4x-IITB-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": {}
}
},
"answers": {
"i4x-IITB-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1":
"choice_0"
},
"attempts": 1,
"max_grade": 1,
"problem_id":
"i4x://IITB/CS101/problem/33e4aac93dc84f368c93b1d08fa984fc"
},
"agent": "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:29.0) Gecko/20100101
Firefox/29.0",
"page": "x_module"
}
{
"username": "tushars",
"host": "localhost",
"event_source": "server",
"event_type":
"/courses/IITB/CS101/2014_T1/instructor_dashboard/api/list_instructor_tasks",
"context": {
"course_id": "IITB/CS101/2014_T1",
"course_user_tags": {},
"user_id": 6,
"org_id": "IITB"
},
"time": "2014-06-20T05:49:26.780244+00:00",
"ip": "127.0.0.1",
"event": "{\"POST\": {}, \"GET\": {}}",
"agent": "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:29.0) Gecko/20100101
Firefox/29.0",
"page": null
}
--
*Thank youPraveen Pal*
More information about the R-help
mailing list