AlejandroR's questions

I have created a function that removes the atypical values ​​on the column of a dataframe by passing the df and the column as parameters:

import numpy as np
def outlier(df, col_name):
    q1 = np.percentile(np.array(df[col_name].tolist()), 25)
    q3 = np.percentile(np.array(df[col_name].tolist()), 75)
    IQR = q3 - q1
                      
    Q3 = q1+(3*IQR)
    Q1 = q3-(3*IQR)
    outlier_num = 0
                      
    for value in df[col_name].values.tolist():
        if (value < Q1) | (value > Q3):
            outlier_num +=1
    return Q1, Q3, outlier_num

The problem is when trying to pass the parameters:

df_covtype = df_covtype[(df_covtype['column_name'] > outlier(df_covtype, 'column_name')[0]) &
              (df_covtype['colum_name'] < outlier(df_covtype, 'column_name')[1])]

It tells me the following:

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-122-e4962bb5c2b0> in <module>()
----> 1 df_covtype = df_covtype[(df_covtype['column_name'] > outlier(df_covtype, 'column_name')[0]) &
      2               (df_covtype['column_name'] < outlier(df_covtype, 'column_name')[1])]
      3 df_covtype.shape

1 frames
<ipython-input-119-f1e12f2fd893> in outlier(df, col_name)
      2 import numpy as np
      3 def outlier(df, col_name):
----> 4     q1 = np.percentile(np.array(df[col_name].tolist()), 25)
      5     q3 = np.percentile(np.array(df[col_name].tolist()), 75)
      6     IQR = q3 - q1

/usr/local/lib/python3.7/dist-packages/pandas/core/generic.py in __getattr__(self, name)
   5485         ):
   5486             return self[name]
-> 5487         return object.__getattribute__(self, name)
   5488 
   5489     def __setattr__(self, name: str, value) -> None:

AttributeError: 'DataFrame' object has no attribute 'tolist'

If anyone can give me a hand, I'd appreciate it. Greetings and thank you

Good morning, I have a database in which I store students and notes. I have the notes of the first exam and the second exam and I have a third empty column in which I want to store these notes.

I'm trying with select to simulate it but it doesn't get me the average of the sum of the two columns:

select nombre, avg(primerexamen+segundoexamen) as media  from dl.modulo1 group by nombre;

If someone can lend me a hand to get this operation.

I plan to do an insert later with the operation indicating that it has to save it in the quarternote column

I am trying to get a kpi sorted from highest to lowest. I get them from the following:

df_partidos.groupby(['home']).agg({'away_score':[np.sum]}).head(10)

I would like to get the results of this kpi sorted from highest to lowest.

I have been looking with:

.sort_values( inplace=True, ascending=False)

But I haven't got any results. If someone can give me a hand

I am trying to clean a column from a pandas dataframe. I have tried to convert an object of type object to int64:

df2['Pts'] = df2['Pts'].astype(int)

But it won't let me because there is a text string in these fields, they are all numeric but in some cases it appears like this: 55[a] or 55[b]

I have tried to remove those text strings that appear at the end of the numbers to be able to convert it, but it is not possible for me.

df2.replace(['[a]', '[b]'], ['', ''])

Could someone suggest me an idea so that those text strings do not appear inside my int values ​​to be able to operate with said data. Thank you very much in advance. All the best

I am trying to get data from a dataFrame to postgres. I have all the data loaded in the dataframe, but when inserting it in postgres it gives me formatting problems.

I have the table created like this:

 CREATE TABLE IF NOT EXISTS DL.desempleo (id varchar(2) NOT NULL, Periodo VARCHAR (10) NOT NULL, Total DECIMAL);

And insert like this:

INSERT INTO DL.desempleo (id,Periodo, Total) values (%s,%s,%d)

Can someone tell me with what format I put the Total value, which is Decimal (7.55), if I put it as %d it gives me the following error:

Error al conectar con PostgreSQL unsupported format character 'd' (0x64) at index %Id

I am trying to load information from different tables into one. I have the following code:

UPDATE coche ch
INNER JOIN modelo mo ON mo.id = ch.codmodelo
INNER JOIN color co ON co.idmodelo = ch.codmodelo
INNER JOIN matricula ma ON ma.idmodelo = ch.codmodelo
SET ch.codmodelo = mo.id, ch.codcolor=co.id, ch.codmatricula=ma.id
WHERE mo.id >0

My intention is to update the fields of the cars table, with a specific field from the model, color and license plate tables.

If someone can help me to understand how to do it. What I have found on the internet or asked has not helped me to solve it. Thanks in advance

I am extracting data from csv to postgres with python. I have used copy_from to input the data from 3 csv's into 3 postgres tables. Now I have to create a 4 table that agrees the results. Would there be a way to extract a specific column from csv with copy_from to insert them into the new table?

Since I already have the data in 3 tables, I was trying to launch a query that merges the data and dumps it into the 4 table.

If someone could advise me to do it in a simple and correct way.

Thank you very much in advance.

Way to do it with copy_from:

    modelo = open(r'modelo.csv', 'r')
    cursor.copy_from(modelo, 'modelo', sep=';')
    connection.commit()
    print("Se han introducido correctamente los datos en la tabla Modelo")

    color = open(r'color.csv', 'r')
    cursor.copy_from(color, 'color', sep=';')
    connection.commit()
    print("Se han introducido correctamente los datos en la tabla Color")

    matricula = open(r'matricula.csv', 'r')
    cursor.copy_from(matricula, 'matricula', sep=';')
    connection.commit()
    print("Se han introducido correctamente los datos en la tabla Matricula")

Way to do it with dataframe:

 df =pd.read_csv('modelo.csv', header=None, names=["id", "modelo", "marca"])

    df2 = pd.read_csv('color.csv', header=None, names=["id", "idmodelo", "color"])

    df3 = pd.read_csv('matricula.csv', header=None, names=["id", "idmodelo", "matricula"])

    engine = create_engine('postgresql://user:[email protected]:5432/bbdd')
    df.to_sql('modelo', con=engine, if_exists='replace', index=False)

I want to extract the month from a full date (DD/MM/YYYY). I have found a way to do it:

int mes = cal.get(Calendar.MONTH);
String nombreMes = mes.getDisplayName(TextStyle.FULL, new Locale("es", 
"ES"));

But it gives me problems with the TextStyle of java.time : it doesn't pick up the import.

Should we add any dependencies in the pom.xml to be able to work with the java.time elements ? If so, can you provide me with the dependency to add in the pom.xml ?

I am trying to iterate through a list of 8 specific items. I would need to show the first three, but it has not been very clear to me how to do it.

I appreciate the help.

<c:forEach begin="0" step="1" end="3" items="${Articulos}">
                <div>${item.idArticulo}</div>
                <a class="destacado my-2" style="word-break: break-word;" 
                  href="${item.url}">${item.nombre}</a> 
</c:forEach>

I know it's not right but at least it serves to explain my doubt.

In the list of articles, I have 8 articles, I want it to show me only 3 articles.

I am doing a validation. I get two strings back, one of them has to be a numeric value less than 10000 and the other string has to have a non-empty String value.

I propose the following:

public boolean validar(String val1, String val2) {
    if(!esNum(gpag) && Integer.parseInt(gpag) > 10000 && q.isEmpty()) {
        return false;
    }else {
        return true;
    }
}
    
public static boolean esNum(String cadena){     
    try{
        if(cadena!= null){
            Integer.parseInt(cadena);
        }
    }catch(NumberFormatException nfe){
         
    }
    return false;
}

Could someone tell me if it is correct or not?

I have to do a check. I have to search for an email through a nif/dni. The thing is that I need to remove the letter from the ID to search for an email associated with said ID.

I have been reviewing the StringUtils class, I have already used it before. The thing is that with split you need a separator character to tell it where to cut the string. Could someone tell me how I could do it, so that I can remove the last character of the ID and verify that it is a letter that it removes?

Thank you very much in advance