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

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

Magic Methods in Python

  What Are Dunder Methods ? In Python, special methods are a set of predefined methods you can use to enrich your classes.  They are easy to recognize because they start and end with double underscores, for example  __init__  or  __str__ . Dunder methods let you emulate the behavior of built-in types.  For example, to get the length of a string you can call  len('string') . But an empty class definition doesn’t support this behavior out of the box: These “dunders” or “special methods” in Python are also sometimes called “magic methods.” class NoLenSupport : pass >>> obj = NoLenSupport () >>> len ( obj ) TypeError : "object of type 'NoLenSupport' has no len()" To fix this, you can add a  __len__  dunder method to your class: class LenSupport : def __len__ ( self ): return 42 >>> obj = LenSupport () >>> len ( obj ) 42 Object Initialization:  __init__ "__init __ ...
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