Skip to main content

PANDAS SERIES - 16 /3/26

 

PRACTICE QUESTIONS


Pandas Series – Practice Questions

1. Write a program to create a Pandas Series containing English alphabets from ‘a’ to ‘z’ and display it.

2. Write a statement to display the alphabets ‘e’ to ‘p’ from the Series EngAlph.

3. Write a statement to display the first 10 values from the Series EngAlph.

4. Write a program to create a Series named 'vow' containing vowels (‘a’, ‘e’, ‘i’, ‘o’, ‘u’) with initial value 0 and display it.

5. Write a statement to set all the values of the Series 'vow' to 10 and display the updated Series.

6. Write a statement to divide all values of the Series 'vow' by 2.

7. Create another Series 'vow1' having 5 elements with index labels ‘a’, ‘e’, ‘i’, ‘o’, ‘u’ and values [2,5,6,3,8] respectively.

8. Write a program to add two Series 'vow' and 'vow1' and store the result in a new Series 'vow3'.

9. Write statements to perform subtraction, multiplication and division between Series 'vow' and 'vow1'.

10. Write a program to change the index labels of Series 'vow' to ['A','E','I','O','U'].

11. Write a program to find the size, dimension and values of the Series 'vow'.



Pandas Series – Answers

1.
import pandas as pd
EngAlph=pd.Series(['a','b','c','d','e','f','g','h','i','j','k','l','m',
                   'n','o','p','q','r','s','t','u','v','w','x','y','z'])
print(EngAlph)

2.
print(EngAlph.iloc[4:16])

3.
print(EngAlph.head(10))

4.
import pandas as pd
vow=pd.Series(0,index=['a','e','i','o','u'])
print(vow)

5.
vow.loc['a':'u']=10
print(vow)

6.
print(vow/2)

7.
vow1=pd.Series([2,5,6,3,8],index=['a','e','i','o','u'])
print(vow1)

8.
import pandas as pd
vow=pd.Series(0,index=['a','e','i','o','u'])
vow1=pd.Series([2,5,6,3,8],index=['a','e','i','o','u'])
vow3=vow+vow1
print(vow3)

9.
print(vow-vow1)
print(vow*vow1)
print(vow/vow1)

10.
vow=pd.Series(0,index=['a','e','i','o','u'])
vow.index=['A','E','I','O','U']
print(vow)

11.
print("Size:",vow.size)
print("Dimension:",vow.ndim)
print("Values:",vow.values)


Comments

Popular posts from this blog

GRADE XII - Python Connectivity with MySQL

  Python Connectivity with MySQL In real-life applications, the data inputted by the user and processed by the application needs to be saved permanently, so that it can be used for future manipulation. Usually, input and output data is displayed during execution but not stored, as it resides in main memory , which is temporary — i.e., it gets erased once the application is closed. This limitation can be overcome by sending the data to be stored in a database , which is made accessible to the user through a Front-End interface . Key Concepts Database A database is an organized collection of data that is stored and accessed electronically from a computer system. DBMS (Database Management System) A DBMS is software that interacts with end-users, applications, and the database to capture and analyze data. Front-End The Front-End is the user interface of the application, responsible for input/output interaction with the user. Back-End The Back-End refe...

GRADE XII - MYSQL CONNECTIVITY WITH PYTHON

  GRADE XII - MYSQL CONNECTIVITY WITH PYTHON SOURCE CODE : #ADD TO DATABASE import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) mycursor=mydb.cursor() v1=input("enter GROCERY ID:") v2=input("enter GROCERY NAME:") v3=int(input("enter PRICE:")) v4=int(input("enter QUANTITY:")) sql='insert into GRO values("%s","%s","%d","%d")'%(v1,v2,v3,v4)  #print(sql) mycursor.execute(sql) mydb.commit() print("*********Grocery Added To Database Successfully*****") #TO VIEW DATA sql="select * from gro" mycursor.execute(sql) res=mycursor.fetchall() print("The AVAILABLE GROCERY details are as follows : ") print("G_ID    NAME     PRICE   QUANTITY") print("\n##*************************************** ************ ##") for x in res:         print(x) print("\n##**...