Project Operation ( P ) in Python

The Project operation selects columns that are given as input.

Let us understand the PROJECT operation better using some examples.

Consider the following table: 

R1 :    FACULTY-1

Example-1 :  Find the list of FName and their salaries..

FName, Salary (Faculty-1)

Output:     

 Example-2 :  Find the list of Qualifications.

                           P Qual (Faculty-1)

Output :                        

Example-3 :  Find the list of Faculty having Ph.D. Qualification.

                          P FName (squal  = ‘Ph.D.’ ( (Faculty-1) )

 Output :                 

Example-4 :  Find the Salaries of Faculty along with their names having

                     MTech qualification.

                P FName, Salary (squal  = ‘MTech’ ( (Faculty-1) )

 Output :