The filter function takes a function and an iterable object as arguments and returns the elements of the iterable that satisfy the function (those for which the function returns the boolean True). We can say that filter filters the iterable leaving only those elements that satisfy the indicated function.
We already know that the built-in function dir returns the set of names associated with an object. For example, if we pass a list as an argument:
a = list([2, 4, 6])
print(dir(a))
The dir function returns the set of names associated with the object included as an argument. If no argument is included, returns the set of names in the local scope.
The pandas.crosstab function returns the contingency table resulting from crossing two or more fields in a dataframe. Although, by default, the result evaluates the frequencies (absolute or relative) of each combination of values, it is possible to specify an aggregation function.
The .drop() method associated with a pandas dataframe returns a copy of it after deleting the indicated rows or columns. These should be referenced by their explicit labels, not by their position on the axis.
The deletion is done, by default, on the vertical axis (rows are deleted, therefore).
The method select_dtypes of pandas dataframes returns the subset of the dataframe formed by the columns of the specified types and can specify the types that you want to select and / or those who want to exclude.
Types can be referenced by name (np.number, for example) or by a text string ("category" , for example).
The COALESCE function receives two or more expressions as arguments and returns the result of the first one that does not return a BLANK.
The LASTNONBLANKVALUE function returns the last value resulting from evaluating an expression that is not a Blank, applying this expression to a table ordered according to the values of a certain column.
The FIRSTNONBLANKVALUE function returns the first value resulting from evaluating an expression that is not a Blank, applying this expression to a table ordered according to the values of a certain column.
The QUARTER function returns the quarter of a date as an integer in the range 1-4.
Excepto donde se indique otra cosa, los contenidos de este sitio web se ofrecen bajo una licencia Reconocimiento-NoComercial-SinObraDerivada 4.0 Internacional