Generación automática de diagramas en Python

  • Status: Closed
  • Prize: €100
  • Entries Received: 1
  • Winner: kavipadm

Contest Brief

Estoy bloqueado en un desarrollo y necesito la ayuda de un programador Python.

Se trata de lo siguiente,

Tengo un conjunto de series de números (3000 registros de 338 valores enteros entre 0 y 5) que representan la ocurrencia de una serie de eventos y su intensidad para una muestra concreta. Por ejemplo, el registro número 1 tendría la forma [1 3 2 1 4 1 1 2 3 4 4 1 1 1 1 1 5 2 5 2 1 1 5 ... etc]. Puedo exportar estos registros desde mi software a formato EXCEL.

A partir de estos datos necesito:

1) construir para cada serie de 338 valores una matriz en python de 26x13.
2) pasar estos valores a una función Python que se proporciona que construye a partir de la matriz un diagrama hinton (NO HAY QUE DESARROLLAR ESTA FUNCIÓN).
3) salvar la imagen generada en formato jpg permitiendo seleccionar la calidad (por defecto 80), nombrando al fichero según el nombre de la serie que aparece en el excel y anotar en el mismo excel en una nueva columna la ruta completa y el nombre de la imagen generada.
4) agrupar estas imagenes en grupos personalizados al ser generadas en bloque (por defecto 10 grupos de 300 imagenes).
5) el script también debe poder invocarse pasando directamente una serie y el nombre del fichero destino a través de un formulario PHP simple. En este modo el script genera el fichero jpg solicitado pero también recorre la excel donde se encuentran todas las series y devuelve el nombre de las 3 series mas similares a la aportada (la similitud se mide de la siguiente manera: se comparan las dos series posición por posición, midiendo la diferencia entre cada par de valores, y se considera que dos series son mas similares si la sumatoria de las diferencias es mas pequeña).

Generar un pequeño documento explicando de forma muy breve el código que generes utilizando algunas capturas con un ejemplo simple.

Sientete libre de pedirme mas detalles.

English translation: (please consider English is not my first lenguage)
I am blocked in a development and I need the help of a Python programmer.

It's about the following,

I have a set of numeric vectors (3000 records of 338 integer values ​​between 0 and 5) that represent the occurrence of some events and their intensity for a specific experiment. For example, record number 1 would have the form [1 3 2 1 4 1 1 2 3 4 4 1 1 1 1 1 5 2 5 2 1 1 5 ... etc]. I can export these records from my software to EXCEL format or CSV.

So From this Excel File I need:

1) build a 26x13 python matrix for each 338-values experiment.
2) pass these matrix ​​to the Python function that is provided ([login to view URL]) that builds a hinton diagram from the matrix (THIS FUNCTION IS ATTACHED SO DOES NOT HAVE TO BE DEVELOPED).
3) save the generated image in jpg format allowing user to select the image quality (default 80), naming the file according to the name of the series that appears in the excel and annotate in the same excel in a new column the complete path and the name of the generated diagram.
4) group these images into custom groups when generated in blocks (by default 10 groups of 300 images).
5) The script must also be able to be invoked by directly passing a string and the name of the destination file through a simple PHP/JSP form. In this mode the script generates the requested jpg file but also crosses the excel where all the series are and returns the name of the 3 series more similar to the one provided (the similarity is measured in the following way: the two series are compared position by position, measuring the difference between each pair of values, and it is considered that two series are more similar if the sum of the differences is smaller).

Generate a small document explaining in a very brief way the code that you generate using some captures with a simple example.

Please Feel U free to ask me for more details.

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • jagarcia1980
    Contest Holder
    • 1 month ago

    Good morning Kavita!, sorry for not answering before but I've had a lot of work these days. It looks fantastic at scrrenshots. If you do not mind, share with me the source code so I can check if the coding meets the requirements and I award you the contest. Thanks for such a quick work, I have another project where I think you can help me, we'll talk once we close this next week.

    • 1 month ago
  • Darflow
    Darflow
    • 1 month ago

    Es requisito usar numpy y scipy para generar las matrices?

    • 1 month ago
  • kavipadm
    kavipadm
    • 1 month ago

    Thanks Sir for the clarification - Also could you please help understand the purpose of groups and why they are necessary. (as well as python version to be used)

    • 1 month ago
  • jagarcia1980
    Contest Holder
    • 1 month ago

    Good evening, thank you for participating in the contest. Im sending U a sample of formated data as it are exported to excel. About what you ask me in your comment, the comparison would be done in absolute value. That is, similar to how a standard deviation works. Two vectors will be more different the more different values they have (position to position) and given two different values, the more different they are (for example 1 and 3 are 2 positions away).About hinton diagrams, are easy to understand, n-square size depends of n-digit vale (1 number is smallest and 5 biggest). In other hand, square color is black when number is >0 and white in other case. You should not have to make any changes to the function that Im attaching. Regards.

    • 1 month ago
    1. kavipadm
      kavipadm
      • 1 month ago

      Thanks Sir for the clarification - Also could you please help understand the purpose of groups and why they are necessary. (as well as python version)

      • 1 month ago
  • kavipadm
    kavipadm
    • 1 month ago

    Hi Sir - I have 2 questions: Could you please provide sample data file and clarify on the similarity between 2 images - since sum of differences between each pair is same as difference between the consolidated sums. Please let me know

    • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!