Skip to main content

Panda's Task

 Consider,

data=pd.DataFrame({'names':['tom','sam',...],'email':['tom21@gmail.com','samdr@yahoo.com','jk21456@abc.com',..],'Firstweekscore':[],'secondweekscore:[]})



d={'names':['tom','sam','ram','kumar'],'email':['tom21@gmail.com','samdr@yahoo.com','ram@gmail.com','k2@gmail.com'],'first_weekscore':[90,90,90,96],'second_weekscore':[92,89,78,87]}
data=pd.DataFrame(d)
print(data)






1.Write a function which will create a new column consisting of average of two scores


    data['average']=(data['first_weekscore']+data['second_weekscore'])/2







2.List comprehension --> create another column which is consisting of scores 93 --> 96



week3=[i+3 for i in data['second_weekscore']] data['week3']=week3 print(data)


3.'gmail.com' -->regular expressions in pandas


print(data[data['email'].str.contains('\w+@gmail.com')==True]) v=data[data['email'].str.contains('\w+@gmail.com')==True] for i in v['email']: print(i.split('@')[0]) print()


4.Select rows which are having gmail address and also secondtestscore greater than 90


d=data[data['email'].str.contains('\w+@gmail.com')==True] v=d[d['second_weekscore']>90] for i in v['email']: print(i.split('@')[0])





5.Create a new column 'group' and randomly assign values as 1,2 and 3


from numpy import random l=random.randint(1,4, size=(4))


data['group']=l


6.Create a pivot table having means of first test scores,by group


table = pd.pivot_table(data=data,index=['group'],aggfunc=np.mean,values="first_weekscore") print(table)





Comments

Post a Comment

Popular posts from this blog

Exception Handling in Python

  Introduction   An error is an abnormal condition that results in unexpected behavior of a program. Common kinds of errors are syntax errors and logical errors. Syntax errors arise due to poor understanding of the language. Logical errors arise due to poor understanding of the problem and its solution.   Anomalies that occur at runtime are known as exceptions. Exceptions are of two types: synchronous exceptions and asynchronous exceptions. Synchronous exceptions are caused due to mistakes in the logic of the program and can be controlled. Asynchronous exceptions are caused due to hardware failure or operating system level failures and cannot be controlled.   Examples of synchronous exceptions are: divide by zero, array index out of bounds, etc.) . Examples of asynchronous exceptions are: out of memory error, memory overflow, memory underflow, disk failure, etc. Overview of errors and exceptions in Python is as follows:     Handling Exceptions   Flowch...
Post a Comment
Read more

Architechture of Kubernetes

  Kubernetes Architecture and Components: It follows the client-server architecture, from a high level, a Kubernetes environment consists of a  control plane (master) , a  distributed storage system  for keeping the cluster state consistent ( etcd ), and a number of  cluster nodes (Kubelets). We will now explore the individual components of a standard Kubernetes cluster to understand the process in greater detail. What is Master Node in Kubernetes Architecture? The Kubernetes Master (Master Node) receives input from a CLI (Command-Line Interface) or UI (User Interface) via an API. These are the commands you provide to Kubernetes. You define pods, replica sets, and services that you want Kubernetes to maintain. For example, which container image to use, which ports to expose, and how many pod replicas to run. You also provide the parameters of the desired state for the application(s) running in that cluster. API Server: The  API Server  is the front-end...
Post a Comment
Read more

Is-A and Has-A relationships in python

  In object-oriented programming, the concept of IS-A is a totally based on Inheritance, which can be of two types Class Inheritance or Interface Inheritance. It is just like saying "A is a B type of thing". For example, Apple is a Fruit, Car is a Vehicle etc. Inheritance is uni-directional. For example, House is a Building. But Building is not a House. #Is-A relationship --> By Inheritance class  A:    def   __init__ ( self ):      self .b= 10    def   mym1 ( self ):      print ( 'Parent method' ) class  B(A):    def   mym2 ( self ):      print ( 'Child method' ) d = B() d.mym1() #output: Parent method d.mym2() #output: Child method HAS-A Relationship:  Composition(HAS-A) simply mean the use of instance variables that are references to other objects. For example Maruti has Engine, or House has Bathroom. Let’s understand...
Post a Comment
Read more