[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