TECHONESPOT
All Tech at one spot
15. WRITE A PROGRAM TO READ FROM A CSV FILE EMPLOYEE.CSV AND CREATE A DATAFRAME FROM IT BUT DATAFRAME SHOULD NOT USE
FILE’S COLUMN HEADER RATHER SHOULD USE ONE COLUMN HEADING EMPID, EMPNAME, DESG, EMPSAL. ALSO PRINT THE MAXIMUM
SALARY GIVEN TO AN EMPLOYEE.
EMPLOYEE CSV FILES CONTAINS (EMPNO, NAME, DESGINATION, SALARY) OF 6 EMPLOYEES.
Solution :-
CSV
import pandas as pd
df = pd.read_csv(“emp.csv”,index_col=”Empno”)
print(df)
print(“Maximum Salary :- “,df.Salary.max())
