Answer:
D) use SQL or graphical tools to query the database
Explanation:
To query the database using SQL or graphical tools will help Howie to retrieve bulk of records from the database according to his requirements and it will help to understand and work with the data in a better way than using the data in raw form.
SQL is a language of database used to manipulate and manage the data in the relational database and to query the database.
It is an easy and faster way to query using SQL or graphical tools because no coding is required here.
Different graphical tools are used to present the data in the database in a way that can be easily understood by a person. Different interfaces are provided to visualize the database tables or schema diagrammatically e.g in the form of graphs etc. Different views of the database can be provided to different users according to their requirement and what information they required to be presented.
Try using at least one capital letter and multiple number and symbols
Example:
[email protected]#3
Answer:
x = 1 ; y = 1
Explanation:
The newly created AVG column will contain the mean value of all 6 columns(P2010, P2011, P2012, P2013, 2014 and P2015) this means that we are taking the mean across the columns as our AVG column have the same length as the initial lengtb of the data Frame as all a values in each index are averaged to create the new column. To achieve this the value 1 will be passed to the axis argument in the apply method.
To drop the previous 6 columns, we se the axis argument set to 1, this will delete the columns passed to the drop method.
Hence, both x and y values of the axis argument will take the value 1.
Treat it like a stop sign and go extra careful :)
The answer to this question is B