File Types: Two major types of files that are stored on a computer Text Files Binary Files Text Files Contains lines of characters. Each line ends with of EOL (End Of Line) character. In Python, a common EOL character is \n. A text file can be read by a program like notepad. Binary Files All… Continue reading File Processing 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
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
First we have to import necessary modules import pandas as pd import csv from random import randint Now we will create data for one month. we can create data directly by using date_range method of Pandas. This will create data with 1 Day interval as default. However, we can specify 2D for 2 Days, 3D… Continue reading Create Random Data with Date Field in Python
pandas is an open source Python library for data analysis. Python has always been great for prepping and munging data, but it’s never been great for analysis – you’d usually end up using R or loading it into a database and using SQL (or worse, Excel). pandas makes Python great for analysis. pandas is a… Continue reading Pandas in Python – Basics
Statistics can be defined as a collection of techniques used when planning a data collection, and when subsequently analyzing and presenting data. Dating back to ancient times people have needed knowledge about population size, to carry out a census of the armies or calculate expected taxes. The word statistics is derived from the word “status”… Continue reading Basics of Statistics
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
Rem Name of the PROCEDURE Dim strProc : strProc =”POPULATE_EMP_DATA” Rem Name of the DB SCHEMA Dim strSchema : strSchema = “bhive_report” ‘########## TARGET DB DSN Dim TargetDSN : TargetDSN = “devDSN” Dim TargetDBuser : TargetDBuser = “devUSER” Dim TargetDBpwd : TargetDBpwd = “devPASS” Call runPROC(TargetDSN,TargetDBuser,TargetDBpwd,strProc,strSchema) Rem Sub Routine to Execute Stored Procedure Rem Generic… Continue reading Vbsript to execute a Oracle PL/SQL Procedure
When the names of files or members specify directories, the operation of tar is more complex. Generally, when a directory is named, tar also operates on all the contents of the directory, recursively. Thus, to tar, the file name `/’ names the entire file system. To archive the entire contents of a directory, use `–create’… Continue reading How to Archive Directories using TAR
Size of a File in a directory location can be checked using a small shell script. #!/bin/bash str_LogName = “/u01/SAQIB/MyFile” int_fileSIZE=$(du -b $str_LogName | awk ‘{ print $1 }’) echo $str_LogName However, if we want to see if the size is greater than a particular amount say 3MB, we will use the following script. #!/bin/bash… Continue reading Check Size of a File in BASH Script – alert.log oracle help
AutomatedCode 