Write R, Python Packages

How to write R, Python packages:



https://python-packaging.readthedocs.io/en/latest/minimal.html

https://hilaryparker.com/2014/04/29/writing-an-r-package-from-scratch/

Change windows command prompt colors

Change windows command prompt colors


http://www.howtogeek.com/howto/16815/how-to-personalize-the-windows-command-prompt/

Windows 10 has Bash

Windows 10 has Bash:

https://www.youtube.com/watch?v=9PXh5l-hGdM

https://www.youtube.com/watch?v=pmXFRfi9rpQ&spfreload=5

Install linux bash on windows 10:

https://www.youtube.com/watch?v=4Jb3R5xSihk&spfreload=5

Linux Package management, apt-get, apt, yum, pacman

Linux Package management,   apt-get, apt, yum, pacman:



https://www.linode.com/docs/tools-reference/linux-package-management


http://sluug.org/resources/presentations/2009/Linux_Package_Management.pdf

http://www.tecmint.com/linux-package-managers/

http://www.tecmint.com/20-linux-yum-yellowdog-updater-modified-commands-for-package-mangement/


https://www.youtube.com/watch?v=RC7bvzIqxS8

https://www.youtube.com/watch?v=pPRLLcF7KRU&spfreload=5


Linux Package Management Part 1-3 on YouTube:


https://www.youtube.com/watch?v=jpxr3Fihnps

https://www.youtube.com/watch?v=gAFXAzhvYpw

https://www.youtube.com/watch?v=bqCUhyqZ1FI

yum, apt-get, apt, and mac

To install apt, apt-get on mac system, using:

http://brew.sh/

For, apt, apt-get, yum, some systems have yum, some have apt, apt-get. If one system has yum, then it probably can not use apt, apt-get.

Here is some coffee system:

http://coffeescript.org/

http://www.linuxha.com/other/Coffee/Coffee.html
  

http://www.tldp.org/HOWTO/html_single/Coffee/



Here is Linux brew:

http://linuxbrew.sh/

Linux grind:

http://virtual-grind.com/tag/linux-2/

https://www.youtube.com/watch?v=K3DbZxY9Zfg

If your Linux can not use apt-get or apt

Recently, I ran into a problem. 

I tried to install gcc on a Linux.

And I tried to use apt-get and apt. But they are not there. And I tried to install apt-get and apt. I could not find the command.

So, I tried the following:

sudo yum -y install gcc gcc-c++ numpy python-devel scipy

And it works. 

 

And I tried 'perl', 'java'. All worked. 

 

sudo yum -y install gcc gcc-c++ numpy python-devel scipy perl java

sudo yum -y install java-1.6.0-openjdk-devel, after install this, then you can use javac, java to run java class.

 

And further, if you use mac, and your  linux there  does not have the apt-get, etc, you can use brew:

http://brew.sh/

it is quite helpful.

 

 

select *, count(*) from table group by * not working on Netezza

select *, count(*) from table group by *  is not working on Netezza.

We need to use something:

select *, count(*) from table group by col1, col2, ...,coln 

How to get the difference between one row and next row for one column in netezza

I am using Netezza for windows. And I tried to get the get the difference between one row and next row  for one column.

I found the function LAG and LEAD.

Here is the query:

select extract(epoch from a.day_id) - extract(epoch from a.lag1) as diff1,day_id from (
select day_id, lag((day_id),1, null) over (order by day_id) as lag1 from table1 where day_id is not null group by day_id ;

A useful link for Eclipse Python IDE

https://www.ics.uci.edu/~pattis/common/handouts/pythoneclipsejava/eclipsepython.html

Things in Netezza similar to spool in Oracle

In oracle, we can use the 'spool' command to output the data in the database to the local drive.

In netezza, there is a nzsql command that can do this. But it seems nzsql can not be used on windows.

From the following link:

http://stackoverflow.com/questions/16396204/can-i-export-the-sql-query-results-from-netezza

We can see that, we can use Workbench Command Line Builder to do this:

menu option Tools -> Workbench Command Line Builder

  
Here is a very detailed explanation:  

https://support.aginity.com/hc/en-us/articles/214809698-Batch-Processing-With-Workbench-

Interesting things about windows

I have used three operating systems, windows, mac and linux.

They are different from each other.

I discovered some interesting things about windows.

1. windows cmd.

It is like DOS.  And it has a lot of commands.

http://ss64.com/nt/

An interesting command I found is 'dir'. Here is a detailed page about 'dir':

http://www.computerhope.com/dirhlp.htm

And the copy and paste things on windows cmd screen is tricky.

https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/windows_dos_copy.mspx?mfr=true

There are more things to discover.

2. WinScp

It is a cool thing to connect local with ftp/linux server etc.

https://winscp.net/eng/docs/guide_install

3. mtputty

It is a multi-tabbed putty system that can put all the putty machine in a whole unit.

4. windows text editor etc

Notepad++

TextPad
 




And there are certain things to discover, like copy certain column(s) in txt file.


For the three systems, windows, mac, linux, windows is something messier than the other two. mac is more classy, and prettier. windows uses exe file for software installation etc. mac uses dmg and app files. linux is neat, unified and need to remember all the commands to use it.