-
Data to JSON , Date conversion?
I want to read data from a MongoDB collection using RapidMiner Studio and will be giving a criteria (a json format) to the Read Mongo DB operator. To do this, I need a datapoint stored in a dataset and converted it to table format using Data to JSON operator. Given that I have a field called 'Date' in ISO date format, when…
-
Attempting to convert CSV file to JSON
I'm totally new. (But been through a LOT of the app tutorials!!) I've played with a lot of the 'Repository' & Importing Data files. Also found an 'Operator' module to 'Read CSV', which shows all info OK under the 'Results' Tab... Now, I found 1 help-page... (cant show 'link' now, as a newbie!!, but it had…
-
On Twitter API feed I am loosing the last digit on the tweet tweet_id using depivot.
Hi I am doing some work on extracting data from the Twitter API, and I am having problems extracting the id for the tweet. I keep loosing the last character. <?xml version="1.0" encoding="UTF-8"?><process version="9.10.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process"…
-
Parametrize a file path
I am using Rapidminer studio in conjunction with AI Hub to read a json document that gives me result. How can I parametrize the input file? I need to test the api where this process is deployed and the user can choose a file while sending the request as form data and results will vary accordingly.
-
Report Generation and Analytics without the App Open
Hello, I wanted to ask if it is possible to have a report generation button as well as analytics in my website and have it work without clicking the play button in rapidminer itself or having the application open? Ive been trying to find a way but I couldnt find a direct answer and so I was confused. The website uses json.…
-
How to filter the unnecessary attributes from JSON TO DATA output
From the output of the JSON TO DATA operator I want to select only specific attributes out of all. Without using SELECT ATTRIBUTE is there any other way? Please suggest me a way.
-
DATA TO DOCUMENT operator not working with JSON TO DATA
<?xml version="1.0" encoding="UTF-8"?><process version="9.7.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.7.000" expanded="true" name="Process"> <parameter key="logverbosity" value="init"/> <parameter key="random_seed" value="2001"/> <parameter…
-
How can I use JSON TO DATA operator on an example set instead of a document?
Actually I am having an example set where one column is having JSON data. Now I want to run the JSON TO DATA operator on that specific column. Is it possible? If yes please help how to do it
-
How can I use JSON TO DATA operator on an example set instead of a document?
Is there any way?
-
JSON processing using JQ operator in Rapidminer
I have simple JSON data in the format as follows: {"A":"a1","B":"b1"}{"A":"a2","B":"b2"}{"A":"a3","B":"b3"} I want the output in the format: A B a1 b1 a2 b2 a3 b3 Please help, it is urgent
-
Series of graphs and json
Hello, I need to prepare a set of graphs based on data file. Exporting them as .png or other formats is not enough for me, as it means, that if the graph is not sufficient and need to redo it, I need to do everything from scratch. I somehow hoped that saving the settings as JSON would be the result, but, as I understand,…
-
Turning JSON Data into Spreadsheed
Hi there RapidMiner Community, I'm currently trying to load JSON data into RapidMiner to use it for a sentiment analysis I'm working on. Browsing threw a lot of the forum content on here regarding the work with JSON data and trying out a lot of the solutions, I sadly haven't found any that worked for me. The data should…
-
Regarding JSON Processing
Hello, i am using data to json to convert the data io json format using datatojson operator and trying to process it but it creates few object files when I store it and could not able to see it as exact json format or json file. Can anyone tell me how to parse it? or how to process it? i want to do ngrams for the input…
-
JSON behind URL to Excel
Dear Rapidminer Community I have about 55 URLs each containing JSON data. How can I crawl the JSON data behind the URLs and combine/convert them to one .xlsx file? Here are three URLs as a…
-
Converting text file containing articles into solr index json format
Hi Folks, I'm creating a chatbot to retrieve content from an article. I have about 10 text files. When I tried using solr, it's accepting json/xml with key/value pair format in it. How do I convert the text to this format? Please help.
-
JSON to data converter converts dates
I am reading data from a MongoDB collection using RapidMiner Studio and converted them to table format using JSON to Data operator. Given that I have a field called 'date' in ISO date format, when I convert JSON to data using the above operator that date format changes to some other format like milliseconds I guess. The…
-
Parsing JSON in RapidMiner using the WebAutomation Extension by Old World Computing
Hi there, we're a consulting company based in Bochum, Germany, specialized on establishing data science and big data as strategic capability in companies. We also develop RapidMiner extensions, bringing a bunch of useful functions to RapidMiner! We thought you might be interested in learning about our extensions and how to…
-
Turn values from JSON row into attribute
I have in my ExampleSet (data from an Excel sheet) one attribute named 'amenities' with massive JSON arrays of values, like so; {TV,"Wireless Internet","Air conditioning","Pets live on this property",Cat(s),"Indoor fireplace",Heating,"Smoke detector","Carbon monoxide detector",Essentials} {TV,Internet,"Wireless…
-
Connect to web API to download a JSON file
I'm trying to connect to an API using the following URL. ratings/v1/companies/94063cdf-3bfa-4e16-b3b5-341da8b00c3c I have a username and the password is NULL. When I use Chrome, I enter these credentials. When I use IE, I am presented the option to download a JSON file. I tried using Enrich Data by Webservice but get an…
-
POST Request with raw body JSON
A package in the marketplace called "RestAPI" supports a simple "POST Request" processor with a parameter "Body Category" (x-www-formurlencoded or raw) and raw data (JSON, XML, HTML, ...) Does the Web Mining package has a similar process? The Get Page process doesn't seem to have these "Raw body" parameters
-
Syntax error: I am getting ? while extracting data using XPATH
Hi, I am trying to extract some data from donedeal.ie website. But I am getting ? instead of values. I am not sure if my syntax is correct or not. I have extracted XPATH using google chrome. Right-click and inspect the element and copy the Xpath. For example, I have extracted following following Xpath…
-
Webscraping JSON Content With RapidMiner
I am a student, RapidMiner novice and I want to scrape from a
site that publishes customer reviews. But I cannot get this to
work in RapidMiner. Here’s an example of the first webpage: https://www.unum.com/employees/benefits/disability-insurance/long-term-disability-insurance?bvstate=pg:1/ct:r RapidMiner can pick…
-
"JSON to data operator"
Hello. I am really new in RapidMiner. Basically, I have a dataset that has .json extension. I was recommended to use JSON to data operator to be able to work with dataset. Unfortunately I could not use the operator. It does not say anywhere, where in the operator to specify which dataset I am intending to work with. I…
-
Exposing "complex" JSON via RapidMiner Server
Hello, World! I am using RapidMiner Server to expose an API that provides zones and coordinates to a custom map. Each zone can contain at least three coordinates, and the custom map creates drawings on these coordinates and performs decorations with other information. I currently have two endpoints looking like this (the…
-
JSON to data and de-pivot with missing attributes and values
Hi everyone, after all i could not find out how to get this problem fixed: i have a JSON file that is inconsistent with its attribute and values, some are missing. Like this:…