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

JENKINS BASICS

  Jenkins  – an open source automation server which enables developers around the world to reliably build, test, and deploy their software. Dashboard: " Dashboard " is the default view shown when you open Jenkins and shows an overview of all  projects configured on a  Jenkins  instance. Creating a New Project: Step 2:  In the next screen, enter the Item name, Choose the ‘Freestyle project option’ Step 3  − The following screen will come up in which you can specify the details of the job. Note  − If you repository if hosted on Github, you can also enter the url of that repository here. In addition to this, you would need to click on the Add button for the credentials to add a user name and password to the github repository so that the code can be picked up from the remote repository. Step 4 − Now go to the Build section and click on Add build step → Execute Windows batch command Before Executing and building a file. Let me describe the task which w...
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

NumPY In python

 NumPy Stands for numerical python How do I install NumPy? To install Python NumPy, go to your command prompt and type “pip install numpy”.  Once the installation is completed, go to your IDE (For example: PyCharm) and simply import it by typing:  “import numpy as np” Here, I have different elements that are stored in their respective memory locations. It is said to be two dimensional because it has rows as well as columns. In the above image, we have 3 columns and 4 rows available. How do I start NumPy? Single-dimensional Numpy Array: 1 2 3 import numpy as np a = np.array([ 1 , 2 , 3 ]) print (a) Output – [1 2 3] Multi-dimensional Array: 1 2 a = np.array([( 1 , 2 , 3 ),( 4 , 5 , 6 )]) print (a) O/P – [[ 1 2 3] [4 5 6]] Python NumPy Array v/s List Why NumPy is used in Python? We use python NumPy array instead of a list because of the below three reasons: Less Memory Fast Convenient The very first reason to choose python NumPy array is that it occupies less memory as co...
Post a Comment
Read more