Data Science · Phython

Finding Mutual friends in Python

Lets take a List of Friends in Users as: users=[ {“id”:0,”name”: ‘Saqib’}, {“id”:1,”name”: ‘Abid’}, {“id”:2,”name”: ‘Muza’}, {“id”:3,”name”: ‘Mustaq’}, {“id”:4,”name”: ‘Sai’}, {“id”:5,”name”: ‘Taha’}, {“id”:6,”name”: ‘Umair’} ] We have 7 Names that have a unique ID as identifier. These can be friends with each other or may know some among themselves. Another List holds the relationship between… Continue reading Finding Mutual friends in Python

Oracle and PL/SQL

Creating Simple Charts in Python

We Have sample data for creating simple Line graphs. You can use this tutorial to generate CSV. TicketID Priority TicketTime Year Month Week Hour 0 TICKET000 Priority-1 2016-01-01 00:00:00 2016 1 53 0 1 TICKET001 Priority-5 2016-01-01 01:00:00 2016 1 53 1 2 TICKET002 Priority-3 2016-01-01 02:00:00 2016 1 53 2 3 TICKET003 Priority-4 2016-01-01… Continue reading Creating Simple Charts in Python

Oracle and PL/SQL

Oracle: Finding Columns with only null values

Consider we are have a table name mytable, which has a lot of  columns and many of them have null values. We can get information about the table using the Oracle built-in namespace. USER_TAB_COLUMNS USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user. Its columns (except for OWNER) are the… Continue reading Oracle: Finding Columns with only null values