What is the proper way to load a CSV file using pandas?1 pointpandas.from_csv(‘data.csv’)pandas.load_csv(‘data.csv’)pandas.read_csv(‘data.csv’)pandas.import_csv(‘data.csv’)

1.Question 1What python object do you cast to a dataframe?1 pointsettuple dictionary2.Question 2How would you access the first-row and first column in the dataframe df?1 pointdf.ix[0,0]df.ix[0,1]df.ix[1,0]3.Question 3What is the proper way to load a CSV file using pandas?1 pointpandas.from_csv(‘data.csv’)pandas.load_csv(‘data.csv’)pandas.read_csv(‘data.csv’)pandas.import_csv(‘data.csv’)

Which method is used to read a CSV file using Pandas?Group of answer choicespd.read_csv()pd.load_csv()pd.csv_read()pd.get_csv()

Which Pandas method is used to load data from a JSON file?Group of answer choicesread_csv()read_data()load_json()read_json()

Assume that you want to read data to a Dataframe and you have written the following code. And also assume that the data file is in the local directory where you are executing the code. Select the correct line of code that will load the data.import pandas as pydatafile_name = 'my-data.csv'col_name = ['name','age','salary','location','class']dataset = pydata.read_csv(file_name, names = col_name)dataset = pd.read_csv(file_name, names = col_name)dataset = pydata.read_csv(url, names = col_name)pydata.read_csv(file_name, names = col_name)

Which pandas function is specifically designed to read Excel files into a DataFrame?pd.read_excel()pd.open_excel()pd.excel_reader()pd.load_excel()