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*
You have not said what your problem is, and you have not shown us the code you
have tried. How are we supposed to know what you want?
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
On June 20, 2014 12:26:03 AM PDT, praveen pal <pal.praveen11 at gmail.com>
wrote:>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
>}