ubigeo | INEI Ubigeo codes in API format

I am showing data from 1 table from SQL Server 2018 to a TreeView. I can only show the tree up to this point

I have one treeview that shows me records of 1 table in SQL Server, so far everything is well attached tree,

The query that I execute to show me the data from the sql to the TREEVIEW is the following:

I'm learning PHP and I was strugling with this XML file.
I was wondering how can I read it and get some data from it.

Can someone please explain to me a few things:

• Because I have seen lots of related questions about registering xml namespaces(I dont know why that is so important)... How do you register every single namespace with getDocNamespaces()?
• How can I access the folder data with this sentence:
  $xml = simplexml_load_file('zip://'.$filename.'.zip'.'#'.$filename.'.xml');
  adding /data/zip:// or zip://../data/ does not work also this is my proyect schema
  

I am trying to plot a heatmap using altair. The idea is that the color mapping is applied independently to each of the rows and not across all the observations. Unfortunately, this is what I get so far.

As you can see on the graph, you can only see changes in one row, because this is the one with more cases. However, the idea is to apply the mapping for each row and not all together.

This is the code that I have so far:

Don't know why, but a Django Command gont create a bluk of entries after reading a CSV file. The command does not work locally or when hosted on Heroku.

I'm using pandas library to read the CSV data, but also using encode('utf-8').

At first it worked, but I had to make some changes to the original file and after saving it and making:

I'm deploying my DjangoApp to Heroku.

I'm following all the documentation but not sure how to set the Procfile to run my command, as I do locally to create my shop_peru DB:

This is what I do locally to create the Peru DB:

I need to create a table from a CSV file.

I think I can do it with different libraries, but in this case I've choosen to use pandas, as I'll need it more in the near future for some data analysis.

I've a script but I'm getting this error:

I have 2 models:

When I am trying to execute my native query, I am facing following exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'f, codigoleyenda cl, tipocomprobante tc, moneda m, cliente c, tipotaxigv ttig, t' at line 1

and my repository is as follows-