qlik-py-tools icon indicating copy to clipboard operation
qlik-py-tools copied to clipboard

Datasets?

Open shaun-hope opened this issue 4 years ago • 2 comments

I'm trying to put these samples on our QSE server for our data science team to play with. I'm having to track down or recreate a lot of data (CSV, xlsx) but I've hit a snag with references to LGA.QVD and LGA-simplified QVD.

Can we obtain these, or can you advise on how to create them?

Are you able to share your /Data folder for these tools since you are appropriately attributing the sources?

Thanks, Shaun

shaun-hope avatar Jan 06 '20 18:01 shaun-hope

Hi Shaun,

For sample apps that use PyTools in the load script, the data sources are provided in the 'Additional App Dependencies' section here. With QSE you'll find the data in the 'attached files' of these apps.

However, some of the capabilities in this SSE are only used through chart expressions and for such sample apps I haven't included the data as I don't expect these to require a reload.

The clustering app which I think you're trying to reload seems to be an exception. I'll look into it, but here are the two files you mentioned for now.

ASGS Structures.zip

Cheers, Nabeel

nabeel-oz avatar Jan 06 '20 23:01 nabeel-oz

Hi Nabeel, @nabeel-oz

Thanks for these two .qvd files for us. I really appritiate that.

I reload some of your app for trying to learn them well, as I think the SSE is cool enabling qlik more powerful.

In Sample_App_Prophet.qvf, LGAs section, you gave us the way to download those data by some token. That's awsome, but I use the Qlik Sense desktop which is not able to connet the internet. I try to copy the url to download the data, but I failed.

Problem 1: In Sample_App_Prophet.qvf, New Nodes List section, you loaded a LoadedAccidentsList.qvd. I couldn't find it. Are you able to give us advice for how we get them or share it to us ?

Problem 2: In Sample_App_Correlations.qvf I can't find table [VIF ERP] in LGA Statistical Profiles 2015.xlsx file, so it couldn't work. I download the data from the link you shared. Could you give kind advice about how we can get the table [VIF ERP]. (Sample App - Correlations.qvf )

Problem 3: I reloaded the Sample App scikit-learn - Train & Test.qvf in Machine Learning part, everthing seems goes well, but in Qlik data load editor, when I try to sync scripted data for these tables, qlik doesn't sync the data to those tables. Is that ok or somewhere I might done wrong?

Problem 4: In Sample-App-Prophet-Multivariate.qvf, 80% code work well, only from Forcast Calandar table in the Forcast Calandar section, it gives erro: Error in expression: ')' expected. I cheched very carefully. It seems no problem with the " ')' expected". Also, in Sample_App_Prophet.qvf, it has almost same Forcast Calandar section which can work well. Is that a bug or something I need to revise.

Problem 5: In the TEMP_TRAIN_TEST table from Sample App scikit-learn - K-fold CV + Grid Search.qvf, the PerformanceRating filed isn't in the HR-Employee-Attrition.xlsx. What is that?

Could you help me with these problems? I know there are many questions, so I hope get your help when you are free.

Looking forward to your reply

Many Thanks, Oli

suprememingjie avatar Sep 01 '21 09:09 suprememingjie