Computer Sc | IP | AI

CONCATENATE DATAFRAMES GRADE XII #The concat() function is used to join more than one dataframe into one unit.  #You can combine dataframes having similar structures. import pandas as pd ''' df1 = pd.DataFrame(     {         "A": ["A0", "A1", "A2", "A3"],         "B": ["B0", "B1", "B2", "B3"],         "C": ["C0", "C1", "C2", "C3"],         "D": ["D0", "D1", "D2", "D3"],     },     index=[0, 1, 2, 3],) df2 = pd.DataFrame(     {         "A": ["A4", "A5", "A6", "A7"],         "B": ["B4", "B5", "B6", "B7"],         "C": ["C4", "C5", "C6", "C7"],         "D": ["D4", "D5", "D6", "D7"],  ...

QUERIES BASED ON CHARITY MYSQL TABLE   GRADE XII Link :  Refer this for only MYSQL Create the following table named "Charity" and write SQL queries for the tasks that follow: Table: Charity I. Display all first names in lowercase II. Display all last names of people of Mumbai city in uppercase III. Display Person Id along with First 3 characters of his/her name. IV. Display first name concatenated with last name for all the employees. V. Display length of address along with Person Id VI. Display last 2 characters of City and Person ID. VII. Display Last Names and First names of people who have "at" in the second or third position in their first names. VIII. Display the position of 'a' in Last name in every row. IX. Display Last Name and First name of people who have "a" as the last character in their First names. X. Display the first name and last name concatenated after removing the leading and trailing blanks. XI. Display Person Id, last names an...

  PATIENT MANAGEMENT PROJECT USING CSV GRADE XII import pandas as pd import matplotlib.pyplot as plt def main():   while True:     print("="*60)     print("enter 1 to ADD PATIENT DETAILS")     print("enter 2 to DELETE PATIENT DETAIL")     print("enter 3 to UPDATE PATIENT DETAIL")     print("enter 4 to SEARCH PATIENT ")     print("enter 5 to DISPLAY PATIENT DETAILS")     print("enter 6 to DISPLAY CITY WISE GRAPH")     print("enter 7 to EXIT....")     d=int(input("enter choice:"))     print("="*60)     if d==1:         add()          elif d==2:         delete()     elif d==3:         update()     elif d==4:         search()     elif d==5:         display()     elif d==6:         gra() ...