Posts

R

PROGRAM 1 csv_data <- read.csv("Y:\\program.csv") print(csv_data) summary(csv_data) csv_data$rowSums <- rowSums (csv_data [, c ("mark1", "mark2", "mark3")], na.rm = TRUE) print (csv_data [, c ("NAME", "subject", "rowSums")]) csv_data$rowMeans <- rowMeans (csv_data [, c ("mark1","mark2", "mark3")], na.rm = TRUE) print (csv_data [, c ("NAME", "subject", "rowMeans")]) csv_data$maxMarks <- apply (csv_data [, c ("mark1", "mark2", "mark3")], 1, max, na.rm = TRUE) print (csv_data [, c ("NAME", "subject", "maxMarks")]) csv_data$minMarks <- apply (csv_data [, c ("mark1", "mark2", "mark3")], 1, min, na.rm = TRUE) print (csv_data [, c ("NAME", "subject”, "minMarks")]) csv_data$meanMarks <- rowMeans (csv_data [, c...
Read more

R PROGRAM

PROGRAM 1 csv_data <- read.csv("Y:\\program.csv") print(csv_data) summary(csv_data) csv_data$rowSums <- rowSums (csv_data [, c ("mark1", "mark2", "mark3")], na.rm = TRUE) print (csv_data [, c ("NAME", "subject", "rowSums")]) csv_data$rowMeans <- rowMeans (csv_data [, c ("mark1","mark2", "mark3")], na.rm = TRUE) print (csv_data [, c ("NAME", "subject", "rowMeans")]) csv_data$maxMarks <- apply (csv_data [, c ("mark1", "mark2", "mark3")], 1, max, na.rm = TRUE) print (csv_data [, c ("NAME", "subject", "maxMarks")]) csv_data$minMarks <- apply (csv_data [, c ("mark1", "mark2", "mark3")], 1, min, na.rm = TRUE) print (csv_data [, c ("NAME", "subject”, "minMarks")]) csv_data$meanMarks <- rowMeans (csv_data [, c ("mark1...
Read more

Python programs

 1) #Using intersection() list1=[10,20,30,40,50,'geeks'] list2=[10,20,'geeks'] if(set(list1).intersection(set(list2))==set(list2)):     print("Sublist exist") else:     print("Sublist not exist") #Getting i/p from user l1=list(input("")) print("List1:",l1) l2=list(input("")) print("List2:",l2) flag=False for i in range(len(l1)-len(l2)+1):     if l1[i:i+len(l2)]==l2:         flag=True         break print("Is sublist present in list....",flag) #Using for loop list1=[10,20,30,40,50] list2=[10,20] list=False for i in range(0,len(list1)):     j=0     while((i+j)<len(list1) and j<len(list2) and list1[i+j] == list2[j]):         j+=1     if j==len(list2):         list=True         break if(list):     print("Sublist exist") else:     print("Sublist not exist") #Using subset() list1=[10,20,30,40,50] list2=[10...
Read more

ARD

1. DDL, DML AND TCL COMMANDS CODING: TABLE CREATION CREATE TABLE EMP_CS051(emp_name VARCHAR (20), emp_id INT, emp_qua VARCHAR (20), job role VARCHAR (20), salary NUMBER (8));    TABLE CREATED INSERTION: INSERT INTO EMP_CS051 VALUES ('GAJA','101','BSC CS','BUSINESS ANALYST','20000');    1 ROW INSERTED INSERT INTO EMP_CS051 VALUES ('MAHA','102','BSC CS','SOFTWARE ENGINEER','25000');    1 ROW INSERTED INSERT INTO EMP_CS051 VALUES ('UKA','103','BSC CS','JUNIOR ENGINEER','23000');    1 ROW INSERTED INSERT INTO EMP_CS051 VALUES ('KIRUTHI','104','BSC CS','JUNIOR ASSISTANT','18000');    1 ROW INSERTED INSERT INTO EMP_CS051 VALUES ('KAVIYA','105','BSC CS','SYSTEM ANALYST','19000');    1 ROW INSERTED INSERT INTO EMP_CS051 VALUES ('SHARMI','106','BSC CS','SENIOR ENGINEER...
Read more