{"id":2216,"date":"2018-02-28T12:42:12","date_gmt":"2018-02-28T07:12:12","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=2216"},"modified":"2018-02-28T12:42:12","modified_gmt":"2018-02-28T07:12:12","slug":"data-science-training-in-mumbai-reading-json-files-using-r-programming-in-visual-studio","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=2216","title":{"rendered":"Data Science Training in Mumbai : – Reading JSON files using R Programming in Visual Studio."},"content":{"rendered":"

\"1\"<\/a><\/p>\n

JSON files stores data as text in human-readable format similar to XML.<\/p>\n

JSON Stands for Javascript object Notation which is commonly used in Web development to pass data.<\/p>\n

Several RESTful web services return data in JSON format and in some ways simpler and more efficient than XML.<\/p>\n

In R programming we can read JSON files and convert them into other formats<\/p>\n

It can be achieved by importing various library which are required to read JSON files these libraries are readily available in CRAN repository.<\/p>\n

\"2\"<\/a><\/p>\n

We can parse the JSON data after reading it in R to further analyse it.<\/p>\n

To create and run our R program in Visual Studio we must first install some tools.<\/p>\n

Now open Visual Studio on your pc and then click on Get Tools and features… inside Tools.<\/p>\n

\"3\"<\/a><\/p>\n

Now in the feature installation window check and install the following features.<\/p>\n

For Visual Studio 2017<\/p>\n

Contains Tools for Data Science<\/p>\n

\"4\"<\/a>
\n<\/br>
\n<\/br><\/p>\n

After this please install R tools from the following link if the above package is not installed properly from the following link<\/p>\n

But it is not necessary<\/p>\n

https:\/\/docs.microsoft.com\/en-us\/visualstudio\/rtvs\/installing-r-tools-for-visual-studio<\/a><\/p>\n

You can also install R programming tool go to the following link for better support and download the software and install it.<\/p>\n

For Windows Users:<\/b><\/p>\n

https:\/\/ftp.iitm.ac.in\/cran\/<\/a><\/p>\n

\"5\"<\/a>
\n<\/br>
\n<\/br><\/p>\n

Type the following command in Visual Studio or R Interactive:<\/p>\n

install.packages(“rjson”)<\/span><\/p>\n

For Linux Users:<\/b><\/p>\n

If you are on Linux platform then you can use this fast and easy command used in Linux which can be used to install R. The yum command is used for installing like this:
\n$ yum install R<\/span><\/p>\n

For Ubuntu Linux or other Debian-related OSs, a more direct method is:
\n$ apt-get install r-base<\/span>\n<\/p>\n

Now let us start creating our R application in visual studio
\nGo to Files ->Project and add a new R project\n<\/p>\n

\"6\"<\/a><\/p>\n

This is our project structure:<\/p>\n

\"7\"<\/a>
\n<\/br>
\n<\/br>
\n<\/br>
\n<\/br><\/p>\n

Now on the top left side is a new R file (script.R) where we can edit source code with all of Visual Studio Ide editing features.
\nAlso on the bottom left of Visual Studio is where you can find an R Interactive window in which you can interactively develop and test code.\n<\/p>\n

We can directly use R Interactive without the need of opening any new project.<\/p>\n

Before we can start coding it is required to create a JSON file in our desired location with .json extension and use the following dummy data in it.<\/p>\n

{

\n “ID”:[“1″,”2″,”3″,”4″,”5″,”6″,”7″,”8” ],
\n “Name”:[“vv”,”ww”,”mm”,”rr”,”Gary”,”Nina”,”Simon”,”Guru” ],
\n “Salary”:[“623.3″,”515.2″,”611″,”729″,”843.25″,”578″,”632.8″,”722.5” ],<\/span>\n<\/p>\n

  “StartDate”:[

\n“1\/1\/2012″,”9\/23\/2013″,”11\/15\/2014″,”5\/11\/2014″,”3\/27\/2015″,”5\/21\/2013”,
\n “7\/30\/2013″,”6\/17\/2014”],
\n “Dept”:[ “IT”,”Operations”,”IT”,”HR”,”Finance”,”IT”,”Operations”,”Finance”]
\n}<\/span>\n<\/p>\n

# Load the package required to read JSON files.
\nlibrary(“rjson”)<\/span>\n<\/p>\n

# Give the input file name to the function.
\nresult <- fromJSON(file = \"D:\\\\RProgramme\\\\1.json\")<\/span>\n<\/p>\n

# Print the result.
\nprint(result)
\n<\/span>\n<\/p>\n

Output:<\/b><\/p>\n

\"8\"<\/a><\/p>\n

# converting Json data to Data Frame
\njson_data_frame <- as.data.frame(result)
\n<\/span>print(json_data_frame)
\n<\/span>\n<\/p>\n

\"9\"<\/a>
\n<\/br>
\n<\/br>
\n<\/br>
\n<\/br>
\n<\/br><\/p>\n

Syllabus of Data Science training in Mumbai<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

JSON files stores data as text in human-readable format similar to XML. JSON Stands for Javascript object Notation which is commonly used in Web development to pass data. Several RESTful web services return data in JSON format and in some … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[1],"tags":[198,199,223,216,215],"yoast_head":"\nData Science Training in Mumbai : - Reading JSON files using R Programming in Visual Studio. - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stepbystepschools.net\/?p=2216\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Science Training in Mumbai : - Reading JSON files using R Programming in Visual Studio. - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"JSON files stores data as text in human-readable format similar to XML. JSON Stands for Javascript object Notation which is commonly used in Web development to pass data. Several RESTful web services return data in JSON format and in some … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=2216\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-28T07:12:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2018\/02\/1-14.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"StepByStepSchoolsSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=2216#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2018\/02\/1-14.png\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2018\/02\/1-14.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=2216#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=2216\",\"name\":\"Data Science Training in Mumbai : - Reading JSON files using R Programming in Visual Studio. - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=2216#primaryimage\"},\"datePublished\":\"2018-02-28T07:12:12+00:00\",\"dateModified\":\"2018-02-28T07:12:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=2216#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=2216\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=2216#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Science Training in Mumbai : – Reading JSON files using R Programming in Visual Studio.\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\",\"name\":\"StepByStepSchoolsSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"caption\":\"StepByStepSchoolsSupport\"},\"url\":\"https:\/\/www.stepbystepschools.net\/?author=40\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Science Training in Mumbai : - Reading JSON files using R Programming in Visual Studio. - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stepbystepschools.net\/?p=2216","og_locale":"en_US","og_type":"article","og_title":"Data Science Training in Mumbai : - Reading JSON files using R Programming in Visual Studio. - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"JSON files stores data as text in human-readable format similar to XML. JSON Stands for Javascript object Notation which is commonly used in Web development to pass data. Several RESTful web services return data in JSON format and in some … Continue reading →","og_url":"https:\/\/www.stepbystepschools.net\/?p=2216","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2018-02-28T07:12:12+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2018\/02\/1-14.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/?p=2216#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2018\/02\/1-14.png","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2018\/02\/1-14.png"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=2216#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=2216","name":"Data Science Training in Mumbai : - Reading JSON files using R Programming in Visual Studio. - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=2216#primaryimage"},"datePublished":"2018-02-28T07:12:12+00:00","dateModified":"2018-02-28T07:12:12+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=2216#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=2216"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=2216#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Data Science Training in Mumbai : – Reading JSON files using R Programming in Visual Studio."}]},{"@type":"Person","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655","name":"StepByStepSchoolsSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","caption":"StepByStepSchoolsSupport"},"url":"https:\/\/www.stepbystepschools.net\/?author=40"}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/2216"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2216"}],"version-history":[{"count":8,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/2216\/revisions"}],"predecessor-version":[{"id":2233,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/2216\/revisions\/2233"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}