LopezAi's questions

I have a lambda that calls putItem to insert a record into a DynamoDB database table.

I get the following access error when executing it:

AccessDeniedException: User: **** is not authorized to perform: dynamodb:PutItem on resource: arn:aws:dynamodb:***:table/*** because no identity-based policy allows the dynamodb:PutItem action

I need to assign a policy to my lambda, exactly one that can perform the putItem function in DynamoBD. I do not know how to do it.

This is my lambda code:

export class NewPlatformIoTCoreStack extends cdk.Stack {
    constructor(scope: Construct, id: string, props?: cdk.StackProps) {
      super(scope, id, props);

      // Rule of IoT Core for MQTT sending of the devices
      
      const constructProps: IotToLambdaProps = {
        lambdaFunctionProps: {
          code: lambda.Code.fromAsset(path.join(__dirname, '../lambdasCode/mqttBroker/')),
          runtime: lambda.Runtime.NODEJS_16_X,
          handler: 'index.handler'
        },
        iotTopicRuleProps: {
          topicRulePayload: {
            ruleDisabled: false,
            description: "Processing of MQTT messages from AWS IoT Stack",
            sql: "SELECT *, topic(4) as device_id FROM 'v1/data/1'",
            actions: []
          }
        }
      };
     
    new IotToLambda(this, 'iot-lambda-integration', constructProps);
      
  };  
}

I have a column with dates, and I want to apply a conditional lambda function, which gives the value one to the 'Type' column in case the values ​​are NaTs. I'm having a lot of problems detecting these NaTs.

With unique I get the empty values, and it tells me that they are NaT

df['fechaActivacion'].unique()

The result is as follows:

array([ 'NaT', '2022-08-02T15:27:28.000000000', '2022-07-09T21:10:03.000000000', ..., '2022-06-27T17:17:50.000000000', '2022- 08-10T21:56:10.000000000', '2022-08-23T17:53:08.000000000'], dtype='datetime64[ns]')

I have tried the following:

df['type'] = df['fechaActivacion'].apply(lambda x: 1 if x == pd.NaT else 0)

I don't get any errors, but all the values ​​are generated as 0, when there are NaT values ​​and 1's should have been generated as well.

Thanks in advance!

I have a dataframe where I need to divide the sensor data into 3 different columns (one for each type of sensor data), and they must match by date.

The following image is how I currently have the df:

The following image is a sample of the output of the df I need:

I attach a link to the original dataframe:

https://drive.google.com/file/d/1-5X1lK8yYkYrS9-2myEa_-njtsdt57cN/view?usp=sharing

I've tried to transpose, but I'm not sure how to do it.

df = df.pivot(index='fechaValor', columns='sensorica', values='Valor')

Thanks in advance.

All the best.

I have to edit the xticks of a histogram that I have painted with .plot, the xticks represent the months in datetime. I would like to display the months, I have tried using a list.

listaMeses = ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'] 

histograma2021 = df_logsFinalizados2021.plot(kind='bar', title = 'Histograma 2021 de viajes por mes')
histograma2021.set(xlabel='Número de viajes', ylabel = 'Mes donde finalizó el viaje', xticks = listaMeses)

I get the following error:

ConversionError: Failed to convert value(s) to axis units: ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre']

Attached image of the histogram.

I don't know if it's a misconception or if I'm close to the goal.

Thanks in advance!

I want to make a nested for in python, where I compare all the records of a dataframe record by record, I have tried this so far (the condition compares if the record of the first for has a Null date and the record of the second for also):

for i in df.index:
    for j in df.index:
        if i!=j and df['idDCL'][i]==df['idDCL'][j] and pd.isnull(df['fechaFin'][i])==True and pd.isnull(df['fechaFin'][j])==True:

I have this dataframe in Python:

I need to group by idCDU and get the dateValue from the maximum value for each idCDU.

This has been my attempt of several:

df_max_fecha = df_max_fecha.groupby(['idCDU', 'fechaValor'])['valor'].max().reset_index()

Any idea is welcome.

Thank you!

I have to get the size of a file from ftp. I get this error

Unable to cast object of type 'System.Net.FileWebRequest' to type 
'System.Net.FtpWebRequest'

on the line I create the FtpWebRequest object. Here is the code I have at the moment:

public static long FtpGetFileSize(string uri, string username, string password)
{
        // Get the object used to communicate with the server

        FtpWebRequest request = (FtpWebRequest)WebRequest.Create(uri);
        request.Method = WebRequestMethods.Ftp.GetFileSize;

        // Get network credentials.
        request.Credentials = new NetworkCredential(username, password);

        try
        {
            using (FtpWebResponse response = (FtpWebResponse)request.GetResponse())
            {
                // Return the size.
                Console.WriteLine("El tamaño del archivo es {0}",response.ContentLength);
                return response.ContentLength;
            }
        }
        catch (Exception ex)
        {
            // If the file doesn't exist, return -1
            // Otherwise rethrow the error
            if (ex.Message.Contains("File unavailable")) return -1;
            throw;
        }                           
}

I need to copy an .exe from a local folder and move it to an ftp server, when I do this the .exe becomes a larger file and won't let me run it. This is the code I have:

public static void FtpBkAndUploadNewVersion(string direccionIP, string username, string password)
    {
        // Get the object used to communicate with the server
        Uri uri = new Uri(string.Concat("ftp://", direccionIP, "/Configurator.exe"));
        FtpWebRequest ftpWebRequest = (FtpWebRequest)WebRequest.Create(uri);
        FtpWebRequest request = (FtpWebRequest)WebRequest.Create(uri);
        request.Method = WebRequestMethods.Ftp.UploadFile;     

        // This example assumes the FTP site uses anonymous logon
        request.Credentials = new NetworkCredential(username, password);

        // Copy the contents of the file to the request stream
        StreamReader sourceStream = new StreamReader(@"C:\Projects\Configurator.exe");
        byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
        sourceStream.Close();
        request.ContentLength = fileContents.Length;

        Stream requestStream = request.GetRequestStream();
        requestStream.Write(fileContents, 0, fileContents.Length);
        requestStream.Close();

        FtpWebResponse response = (FtpWebResponse)request.GetResponse();

        Console.WriteLine("Upload File Complete, status {0}", response.StatusDescription);

        response.Close();  
    }  

I have to upload a file to an ftp server (local host 127.0.0.1) but first I have to make a backup of that file (with a different name from the original) from where I upload it, this second part is what I can't do. Here is what I have so far:

//Upload a file from a X Path to the FTP Server and backup of the file
public static void FtpUploadExeAndBk(string direccionIP, string username, string password)
{
    // Get the object used to communicate with the server
    Uri uri = new Uri(string.Concat("ftp://", direccionIP, "/", "Configurator.exe"));
    FtpWebRequest ftpWebRequest = (FtpWebRequest)WebRequest.Create(uri);
    FtpWebRequest request = (FtpWebRequest)WebRequest.Create(uri);
    request.Method = WebRequestMethods.Ftp.UploadFile;

    // This example assumes the FTP site uses anonymous logon
    request.Credentials = new NetworkCredential(username, password);

    // Copy the contents of the file to the request stream
    StreamReader sourceStream = new StreamReader(@"C:\Projects\Configurator.exe");
    byte[] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
    sourceStream.Close();
    request.ContentLength = fileContents.Length;

    //Hacer el backup y que se quede en la carpeta local (renombrar) ?????
    StreamReader sourceStreamBk = new StreamReader(@"C:\Projects\Configurator.exe");
    sourceStreamBk.ToString=sourceStreamBk.ToString.Concat("_bk");
    //??????

    Stream requestStream = request.GetRequestStream();
    requestStream.Write(fileContents, 0, fileContents.Length);
    requestStream.Close();

    FtpWebResponse response = (FtpWebResponse)request.GetResponse();

    Console.WriteLine("Upload File Complete, status {0}", response.StatusDescription);

    response.Close();
}  

My code makes a backup of a folder, if the backup folder exists it creates another adding "_1" and if it doesn't it creates a new one. I don't know how to make it so that when there is more than one backup folder, it automatically generates another one without the name matching, I leave you here the code that I have obtained so far:

//backup del directorio destino en otra carpeta
private static void directoryCopy(string sourceDirName, string destDirName, bool copySubDirs)
{
    // Get the subdirectories for the specified directory.
    DirectoryInfo dir = new DirectoryInfo(sourceDirName);
    DirectoryInfo[] dirs = dir.GetDirectories();



    if (!dir.Exists)
    {
        throw new DirectoryNotFoundException(
            "Source directory does not exist or could not be found: "
            + sourceDirName);
    }

    if (Directory.Exists(destDirName))
    {
        destDirName = destDirName + "_1";
        Directory.CreateDirectory(destDirName);
    }
    else
    // If the destination directory doesn't exist, create it. 
    {
        Directory.CreateDirectory(destDirName);
    }

    // Get the files in the directory and copy them to the new location.
    FileInfo[] files = dir.GetFiles();
    foreach (FileInfo file in files)
    {
        string temppath = Path.Combine(destDirName, file.Name);
        file.CopyTo(temppath, false);
    }

    // If copying subdirectories, copy them and their contents to new location. 
    if (copySubDirs)
    {
        foreach (DirectoryInfo subdir in dirs)
        {
            string temppath = Path.Combine(destDirName, subdir.Name);
            directoryCopy(subdir.FullName, temppath, copySubDirs);
        }
    }
}

I have to test that when looking for a file by name in a directory it does not exist and it indicates it to me on the screen. I show you my code, where the question mark comment is where I have the problem, the rest works correctly:

static void recorrerDirectoriosYCompararPorFicheros(string dir1, string dir2)
{
    System.IO.DirectoryInfo dirOrigenInfo = new DirectoryInfo(dir1);
    System.IO.DirectoryInfo dirDestinoInfo = new DirectoryInfo(dir2);

    System.IO.FileInfo[] fileDirOrigenNames = dirOrigenInfo.GetFiles("*.*");
    System.IO.FileInfo[] fileDirDestinoNames = dirDestinoInfo.GetFiles("*.*");

    for (int i = 0; i <= (fileDirOrigenNames.Length) - 1; i++)
    {
        System.IO.FileInfo file = fileDirOrigenNames[i];
        for (int j = 0; j <= (fileDirDestinoNames.Length) - 1; j++)
        {
            System.IO.FileInfo file2 = fileDirDestinoNames[j];
            if (file.Name.Equals(file2.Name))
            {
                mostrarResultadoComparacionPropiedades(file.FullName, file2.FullName);
            }
            else//????????????????????
            {
                Console.WriteLine("\nEl archivo {0} no existe en {1}", file.Name, dir2);

            }
        }

    }

}

Here I leave the result, it tells me comparison by comparison if it exists or not, what I want is for the directory to be traversed and tell me only once if it exists or not, the file that does not exist is c.txt: Date of Creation or last modification NO are the same The files C:\Projects\Folder\a.txt and C:\Projects\Folder taDestino\a.txt are not the same by date of creation and by last modification

The a.txt file does not exist in C:\Projects\DestinationFolder

The a.txt file does not exist in C:\Projects\DestinationFolder

The a.txt file does not exist in C:\Projects\DestinationFolder

The c.txt file does not exist in C:\Projects\DestinationFolder

The c.txt file does not exist in C:\Projects\DestinationFolder

Creation date and last modification are the same The C:\Projects\FolderSource\c.txt and C:\Projects\FolderDestin o\c.txt are the same by date of creation and by last modification

The c.txt file does not exist in C:\Projects\DestinationFolder

Configuration.ini file does not exist in C:\Projects\DestinationFolder

Configuration.ini file does not exist in C:\Projects\DestinationFolder

Configuration.ini file does not exist in C:\Projects\DestinationFolder

Date of Creation or last modification are NOT the same The files C:\Projects\FolderFolder\Configuration.ini and C:\Projects\FolderDestination\Configuration.ini are not the same by date of creation and by date of last modification

I have to take the files from a directory one by one and look in another directory for a file with the same name. Once they match, I have to call mostrarResultadoComparacionPropiedades()passing their paths as parameters. My code is this:

     static void recorrerDirectoriosYCompararPorFicheros(string dir1, string dir2)
     {
         System.IO.DriveInfo dirOrigen = new System.IO.DriveInfo(dir1);
         System.IO.DriveInfo dirDestino = new System.IO.DriveInfo(dir2);

         System.IO.DirectoryInfo dirOrigenInfo = dirOrigen.RootDirectory;
         System.IO.DirectoryInfo dirDestinoInfo = dirDestino.RootDirectory;

         System.IO.FileInfo[] fileDirOrigenNames = dirOrigenInfo.GetFiles("*.*");
         System.IO.FileInfo[] fileDirDestinoNames = dirDestinoInfo.GetFiles("*.*");

         for (int i = 0;i<=(fileDirOrigenNames.Length)-1;i++ )
         {
             System.IO.FileInfo file = fileDirOrigenNames[i];
             for (int j = 0; j <= (fileDirDestinoNames.Length)-1; j++)
             {
                 System.IO.FileInfo file2 = fileDirDestinoNames[j];
                 if (file.Name.Equals(file2.Name))
                 {
                     mostrarResultadoComparacionPropiedades(file.DirectoryName, file2.DirectoryName);
                 }
             }
         }
     }

Here are the methods to compare two files by properties:

    static bool compareFilesByProperties(string file1, string file2)
    {
        DateTime fechaCreacion1 = File.GetCreationTime(file1);
        DateTime ultimaModificacion1 = File.GetLastWriteTime(file1);

        DateTime fechaCreacion2 = File.GetCreationTime(file2);
        DateTime ultimaModificacion2 = File.GetLastWriteTime(file2);

        if ((fechaCreacion1.Date.Equals(fechaCreacion2.Date)) &&(ultimaModificacion1.Date.Equals(ultimaModificacion2.Date)))
        {
            Console.WriteLine("Fecha de Creación y última modificación son iguales");
            return true;
        }
        Console.WriteLine("Fecha de Creación o última modificación NO son iguales");
        return false;

    }

    static void mostrarResultadoComparacionPropiedades(string file1, string file2)
    {
        if (compareFilesByProperties(file1, file2)==true)
        {
            Console.WriteLine("Los  {0} y {1} son iguales por fecha de creación y por última modificación",file1, file2);
        }
        else
        {
            Console.WriteLine("Los archivos {0} y {1} no son iguales por fecha de creación y por última modificación", file1, file2);
        }
    }

I have an array of files, and I need to get the path string of one. I can't find any method that does it. What the code does is go through two file directories, and then look for the first file in the source directory in the destination directory. This is my code so far, the questions indicate the question I have:

 for (int i = 0;i<fileDirOrigenNames.Length;i++ )
 {
      System.IO.Stream[] arrayOrigen = new System.IO.Stream[i];

      for (int j = 0; j <= fileDirDestinoNames.Length; j++)
      {
            System.IO.Stream[] arrayDestino = new System.IO.Stream[i];
            if (arrayOrigen[i].Equals(arrayDestino[j]) == true)
            {
                //???????    mostrarResultadoComparacionPropiedades(arrayOrigen[i].ToString, arrayDestino[j].ToString);
            }
       }
}

I have to store the files in a directory in an array and then iterate through that array.

System.IO.DriveInfo dirOrigen = new System.IO.DriveInfo(ruta1);

System.IO.DirectoryInfo dirOrigenInfo = dirOrigen.RootDirectory;

System.IO.FileInfo[] fileDirOrigenNames = dirOrigenInfo.GetFiles("*.*");

for (int i=0;i<fileDirOrigenNames.GetLength;i++ )
{
...
}

At the moment I have this code, it gives me an error in the forconfileDirOrigenNames.GetLength

I need to compare two text files by their properties in C#, and not by their content. For example, by date created and by date modified. I have managed to compare it by content, I leave here the code:

private bool FileCompare(string file1, string file2)
{
     int file1byte;
     int file2byte;
     FileStream fs1;
     FileStream fs2;

     if (file1 == file2)
     {
          return true;
     }

     fs1 = new FileStream(file1, FileMode.Open);
     fs2 = new FileStream(file2, FileMode.Open);

     if (fs1.Length != fs2.Length)
     {
          // Close the file
          fs1.Close();
          fs2.Close();

          return false;
     }

     do 
     {
          // Read one byte from each file.
          file1byte = fs1.ReadByte();
          file2byte = fs2.ReadByte();
     }
     while ((file1byte == file2byte) && (file1byte != -1));

     fs1.Close();
     fs2.Close();

     return ((file1byte - file2byte) == 0);
}

I have to display on the screen a specific line of a .txt file, in C#. My code so far is this:

while (!file.EndOfStream)
{
    counter++;

    if (counter == 4) {
        line = file.ReadLine();
        System.Console.WriteLine(line);
    }

}

I have also tried with this code but I get the first line:

 while (!file.EndOfStream)
{
    line = file.ReadLine();
    //System.Console.WriteLine(line);
    if (++counter ==4) break;

}

Also know to see if a specific line could be read but detecting a string of characters.

Properties: 
Name=X 
Path=X 
Version=1.000

The text file looks something like this, I need to read the version, it's just for testing.