$ODCLBRD${"onedataVersion":{"clientVersion":"1.188.0","serverVersion":"46.46.2-SNAPSHOT","bundleVersion":"3.28.1"},"reports":[],"workflow":{"id":"0d0b70b3-fbeb-4a25-a88f-84c67019ea02","versionNumber":24,"name":"Step 2. House Price Prediction: Load Models and Predict Prices","tags":[],"description":"","notes":null,"createdAt":"2020-11-09T09:56:42.549Z","updatedAt":"2020-11-13T14:29:38.182Z","projects":[{"id":"279c4642-8683-453e-b675-38baeabb1f57","projectType":"USE_CASES","owner":"d40abed4-8cea-4ba3-9716-dd23903fbd9a","name":"Matthi's TestProject","description":null,"notes":null,"tags":[],"createdAt":"2020-02-26T09:16:11.985Z","updatedAt":"2020-11-12T10:30:06.313Z","secured":false,"ownerInformation":null}],"nodes":{"61dfbde9-b8a7-4b96-967e-4c82656c3ea5":{"id":"61dfbde9-b8a7-4b96-967e-4c82656c3ea5","processor":"00000000-0000-0000-0014-000000000001","config":{"take":400,"sortBy":[],"groupBy":[],"tablename":"","order":["ASC"]},"result":null,"options":{"configEditExpertModeEnabled":false,"x":200,"y":263,"name":"Result Table","color":"#0d47a1"},"out":{}},"7c46e583-6bfb-4845-9ef6-a6a0180e73f6":{"id":"7c46e583-6bfb-4845-9ef6-a6a0180e73f6","processor":"00000000-0000-0000-0065-000000000002","config":{"multipleModelLoad":{"triggerState":false,"values":{}},"multipleModelGroupSave":{"triggerState":false,"values":{}},"generateEmptyDatasetOutput":false,"multipleModelGroupLoad":{"triggerState":true,"values":{"0":{"modelGroupLoad":{"reference":{"type":"referenceById","id":"3dbeed00-13bf-4d98-a4cb-edee7290bb9e"}}}}},"multipleModelSave":{"triggerState":false,"values":{}},"manuallyAdded":[],"tablename":"","inputName":"input","script":"import pandas as pd\n\npd.options.mode.chained_assignment = None\n\n# od_input keys represent name of the input dataset set in OD processor\ndf = od_input['input'].get_as_pandas()\n\n\ncountries = df.country.unique()  # Select distinct countries\nnum_countries = len(countries)   # Count distinct countries\nmodels=[[]]*num_countries         # a matrix to write models, number of models = num of countries\n\ndf_output = pd.DataFrame(columns = ['area', 'price', 'country'])  #define empty output dataset \ndf.loc[:, 'price'] = 0\n\nfor idx in range(num_countries):         # Go through all countries to create prediction\n    model_name = countries[idx] + '_price_model'\n    X_test = df[df['country'] == countries[idx]]\n    models[idx]= od_models[model_name]   # find model for the current country\n    prediction = models[idx].predict(X_test[['area']])\n    X_test['price']=prediction\n    #X_test.loc[:, 'price']=prediction\n    df_output = pd.concat([df_output, X_test])\n\n#Output of predictions for every country\nod_output.add_data(\"output\", df_output)\n","timeout":300},"result":null,"options":{"configEditExpertModeEnabled":false,"x":200,"y":151,"name":"Python-Script Single Input: predict prices","color":"#d5672d"},"out":{"output":{"61dfbde9-b8a7-4b96-967e-4c82656c3ea5":"data"}}},"debabd6e-1132-49ac-b67a-9109aef3490d":{"id":"debabd6e-1132-49ac-b67a-9109aef3490d","processor":"00000000-0000-0000-0001-000000000004","config":{"dataLocation":{"reference":{"type":"referenceById","id":null}},"parseMode":["FAIL_FAST"],"tablename":""},"result":null,"options":{"configEditExpertModeEnabled":false,"x":225,"y":38,"name":"Data Table Load: homeprices_predict","color":"#78909c"},"out":{"data":{"7c46e583-6bfb-4845-9ef6-a6a0180e73f6":"dataframe"}}}},"nodeNotes":{},"owner":"d40abed4-8cea-4ba3-9716-dd23903fbd9a","resourceType":"WORKFLOW","groups":[],"auxiliaries":[],"variables":[],"recentExecution":"ccb3e9eb-f50c-4851-a9b1-ef2bacc2dbcb","jobNamingRule":"#@sys_job_version@","ownerInformation":{"type":"user","ownerId":"d40abed4-8cea-4ba3-9716-dd23903fbd9a","firstName":"Matthias","lastName":"Rauch"},"permissions":["READ","WRITE","CREATE","DELETE","EXECUTE","SHARE"],"sinks":[]}}