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()

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()

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’)

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

pandas is a machine learning librarypandas provides functionality for loading, manipulating and analysing datapandas is part of the Python standard librarypandas is a free, open-source library

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)