14 September 2016

Short List: The useful Cloud Terminology for new Beginners

By With No comments:
AWS
The organizational unit of Amazon that provides a variety of cloud services. AWS operates from 11 physical locations across North and South America, Europe, Asia, and Australia.

Content delivery network (CDN)

A distributed system consisting of servers in discrete physical locations, configured in a way that clients can access the server closest to them on the network, thereby improving speeds.

Cloud

Cloud TerminologyA metaphor for a global network, first used in reference to the telephone network and now commonly used to represent the internet.

Cloud portability

The ability to move applications and data from one cloud provider to another. See also Vendor lock-in.

Cloud provider

A company that provides cloud-based platform, infrastructure, application, or storage services to other organizations and/or individuals, usually for a fee.

Cloudsourcing

Replacing traditional IT operations with lower-cost, outsourced cloud services.

Cloud storage

A service that allows customers to save data by transferring it over the internet or another network to an offsite storage system maintained by a third party.

Cloudware

Software that enables creating, deploying, running, or managing applications in the cloud.

Cluster

A group of linked computers that work together as if they were a single computer, for high availability and/or load balancing.

Consumer cloud

Cloud computing offerings targeted toward individuals for personal use, such as Dropbox or iCloud.

Consumption-based pricing model

A pricing model whereby the service provider charges its customers based on the amount of the service the customer consumes, rather than a time-based fee. For example, a cloud storage provider might charge per gigabyte of information stored. See also Subscription-based pricing model.

Content Management Interoperability Services (CMIS)

An open standard for controlling content and document management systems and repositories using web protocols.

Customer self-service

A feature that allows customers to provision, manage, and terminate services themselves, without involving the service provider, via a web interface or programmatic calls to service APIs.

Disruptive technology

A business term that describes innovations that improve products or services in unexpected ways. These innovations change the methods used to accomplish a task, and re-shape the market for that task. Cloud computing is considered a disruptive technology because of its elasticity, flexible pricing models, and maintenance cost compared to traditional IT service provisioning.

01 September 2016

2 Myths about Python String Comparison

By With 1 comment:
Python String Comparison
Python String Comparison

Comparing Strings 

It’s possible to compare strings just as you would numbers. Keep in mind, however, that Python is picky about strings being equal to each other. If the two strings differ, even slightly, they’re not considered the same.

Consider the following example:

>>> a = "Virginia"
>>> b = "virginia"
>>> a == b False

Although a and b are very similar, one is capitalized and one isn’t. Because they aren’t exactly alike, Python returns False when we ask whether they are alike. Whitespace matters, too.

Consider the following code snippet:

>>> greet1 = "Hello "
>>> greet2 = "Hello"
>>> greet1 == greet2 False greet1 has a space at the end of its string whereas greet2 does not. Python looks at whitespace when comparing strings, so the two aren’t considered equal

29 August 2016

How To Solve Excel problems with best SAS utility

By With No comments:

Reading an Excel file into SAS

Suppose that you have an Excel spreadsheet called auto.xlsx. The data for this spreadsheet are shown below.

MAKE MPG WEIGHT PRICE
AMC Concord 22 2930 4099
AMC Pacer 17 3350 4749
AMC Spirit 22 2640 3799
Buick Century 20 3250 4816
Buick Electra 15 4080 7827
Using the Import Wizard is an easy way to import data into SAS.  The Import Wizard can be found on the drop down file menu.  Although the Import Wizard is easy it can be time consuming if used repeatedly.  The very last screen of the Import Wizard gives you the option to save the statements SAS uses to import the data so that they can be used again.  The following is an example that uses common options and also shows that the file was imported correctly.

PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\auto.xl"
DBMS=xlsx REPLACE
SHEET="auto"; 
GETNAMES=YES;
RUN;
  • The out= option in the proc import tells SAS what the name should be for the newly-created SAS data file and where to store the data set once it is imported. 
  • Next the datafile= option tells SAS where to find the file we want to import. 
  • The dbms= option is used to identify the type of file being imported. 
  • The replace option will overwrite an existing file.
  • To specify which sheet SAS should import use the sheet="sheetname" statement.  The default is for SAS to read the first sheet.  Note that sheet names can only be 31 characters long.
  • The getnames=yes is the default setting and SAS will automatically use the first row of data as variable names.  If the first row of your sheet does not contain variable names use the getnames=no

Writing Excel files out from SAS

It is very easy to write out an Excel file using proc export in SAS.
Here is a sample program that writes out SAS data called mydata to an Excel file called mydata.xlsx into the directory "c:\dissertation".

proc export data=mydata outfile='c:\dissertation\mydata.xlsx' 
dbms = xlsx replace;
run;

28 August 2016

10 Excel topics for an excellent data career

By With No comments:
The below listed topics help you get solid footing in Excel Analytics. Just practice these 10 topics step by step and by completing all, you will be an expert in Excel.

  1.  Tables in Excel
  2. Grabbing data from external sources
  3. Cleaning data with functions
  4. Working with Pivot tables
  5. Writing Formulae for Pivot tables
  6. Pivot Charts
  7. How to use data base functions
  8. How to use statistics
  9. Inferential Statistics
  10. Descriptive statistics