Saturday, 31 December 2016

Learning Pandas - DataFrame #2

Friday, 30 December 2016

Learning Pandas - Series #1

Wednesday, 28 December 2016

Learning Graphlab - SFrame #2

In last post Learning Graphlab - SFrame #1, we have learn basics of SFrame, like how to create, add or delete the columns in SFrame. In this post, we will revise it once again and learn some advance features of SFrame. Have a good learnng !!!

You can view the Jupyter Notebook for the same HERE




Thursday, 22 December 2016

DataStage Scenario #17 - Get Transitive relation between columns


Goal : To get the data from two columns which have transitive relationship between them

A -> B
B -> C

then 

A -> C



Input
Col1 Col2
a b
b c
s u
u p
1 2
2 3






Output
Col1 Col2
a c
s p
1 3




Like the below page to get update  

Wednesday, 21 December 2016

R Points #2 - DataFrame & List Basics

Sunday, 18 December 2016

R Points #1 - Matrix & Factor Basics

Saturday, 17 December 2016

R Points #0 - Basics n Vector




=======================================================
=======================================================



Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/

Monday, 12 December 2016

vmware player powering on internal error



vmware workstation logoLast night, I struggled with "vmware player powering on internal error" for almost an hour when I was trying to run a vmware os on my machine and followed so many tweaks to resolve this but no success.
After lots of googling, I found one solution which worked for me So sharing the same here if it can help someone stuck like me :)


Thursday, 8 December 2016

Notepad++ tip - Format JSON file


Notepad++ is a very powerful tool with lots of plugins and functionality which can reduce a lot of our work. Today, we will see how to deal with JSON data in Notepad++.

1. First of all, whenever you are opening any data or code file, always select respective language style. How you do it is below -

Open data/code file --> Go to Language Menu --> Select respective language setting (in our case, its J - JSON )

After doing this, you will see that code/data text is more visible to your eyes.

2. Install some plugins, for JSON, install below ones -
a. JSON Viewer
b. JSToolNpp

Go to Plugins --> Plugin Manager --> Show Plugin Manager --> Available ---> Select & Install

3. For formatting JSON, select all content, now use Ctrl+Alt+Shift+M or Ctrl+Alt+J
4. Your JSON file has been formatted :-)

You can download some useful plugins from here ->  http://bit.ly/2h5iygb
If dont have access, Use this - https://db.tt/H5VKcNA0

Place this plugin folder into your notepad++ installation directory and restart the notepad++.





Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/

Wednesday, 7 December 2016

Import the jobs from DS windows client


As we have discussed a script which can export the datastage jobs from your client system (http://bit.ly/2frNPKj) likewise we can write another one to import the jobs. Let's see how -


DsImportJobsClient.bat :

This Script read all the *.dsx job name from the specified Directory and Sub-Directory and import to the Specified project. It can also build (Only BUILD) the existing package created on Information Server Manager and send it to the specified location on client machine.

To use the build feature you need to make sure the package has been created with all the needed jobs, saved and closed. Only update to the selected job will be taken care automatically. To add/delete a job, you need to do manually.

Modify the Import.properties and ImportJobList.txt file and Go the .bat dir and then execute the importAndBuild.bat.




Import.properties :


ImportJobList.txt :


DsImportJobsClient.bat :





Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/