[Qgis-user] [QGIS-user] Convert r.report output from txt to csv/xls

[Ari Meyer]

Just a question, given the discussion here.  Shouldn't such a report be
generated in a structured format like YAML/JSON/XML for easier parsing?
Would this merit an enhancement request?
Ari

On Tue, Jan 18, 2022 at 6:54 PM chris hermansen <clhermansen at gmail.com>
wrote:

> Nicolás, Igor and list,
>
> On Tue, Jan 18, 2022, 16:40 Nicolas Cadieux <njacadieux.gitlab at gmail.com>
> wrote:
>
>> Hi,
>> The r.report is a rather complicated text file that contains a lot of
>> characters made for improving the look of the output.  On way could be to
>> python your way thought it so that is can find your way to the proper
>> information.  This would save time if you have lots of files.
>>
>
> Or if you have to process the same file many times because your data is
> evolving.
>
>>
>> The faster way, if you don’t program is to use a mixture of notepad++
>> along with excel or open office.  You can easily remove all useless
>> characters like and replace them by no string or with a “,”.  Then you can
>> import in open office.  I like OpenOffice Calc for this because you can
>> they is to merge multiple separation characters into one.  This could help
>> with the imports.  For example, if you have “line 1…….data,data,data”, you
>> could use both the dot and the comma as separators and the multiple dots
>> would be merged as one unique separator.
>>
>
> Or not... If your decimal points are dots.
>
>>
>> If you have multiple files, you could use concatenation to make one big
>> .csv file.  For windows, use the example could here.
>> https://superuser.com/questions/111825/a-command-line-or-batch-cmd-to-concatenate-multiple-files
>>
>> Hope this helps.  This by the way is an excellent way to start learning
>> Python programming.  Python has easy of way to read and write.txt file and
>> multiple way to manipulate text strings.  Great project if you have the
>> time to learn.
>>
>
> I have to transform data files like this quite often.
>
> Generally whether using Python or another programming language, you want
> to use regular expressions to match and transform text patterns. The
> learning curve can be a bit steep but very worthwhile.
>
> On Unix / Linux there is a specialized language for this type of transform
> called awk. It's probably available for Windows somewhere. The advantage of
> awk is there is no programming overhead for reading and writing lines; the
> awk programs are statements reacting to the input received from the file.
>
>>
>> Nicolas Cadieux
>> https://gitlab.com/njacadieux
>>
>> Le 18 janv. 2022 à 19:18, Igor Oliveira Ribeiro <
>> igorgeoinformacao at gmail.com> a écrit :
>>
>> 
>> Hi,
>> I have been using qgis version 3.10 and 3.16. I've been using the
>> r.report tool to extract some data from a raster. Currently, the report is
>> generated from r.report in *.txt format. I would like to know if it is
>> possible to convert this format to csv/xls, within QGIS?
>>
>> --
>>
>> See our last paper:  <https://doi.org/10.1016/j.envpol.2020.114029>
>>
>> Impact of biomass burning on a metropolitan area in the Amazon during the
>> 2015 El Niño: The enhancement of carbon monoxide and levoglucosan
>> concentrations. <https://doi.org/10.1016/j.envpol.2020.114029>
>>
>> Igor Oliveira Ribeiro
>>
>> Post-Doc on Regional Climate Change, Vulnerability, Impacts and
>> Adaptation - Cuomo Foundation/UEA
>>
>> +55 92 98103 7136 | skype: igorflorestal
>>
>> Universidade do Estado do Amazonas | Instituto Nacional de Pesquisas da
>> Amazônia
>>
>> Visite: www.geoescrita.com.br
>>
>> <https://www.linkedin.com/in/igoroliveiraribeiro/>
>> <https://www.instagram.com/geoescrita/>
>> <https://www.researchgate.net/profile/Igor_Oliveira_Ribeiro>
>> <http://lattes.cnpq.br/3909691804095045>
>> <https://orcid.org/0000-0002-3529-0525> <https://www.geoescrita.com.br/>
>>
>> Think globally, act locally!
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220118/cceb91ef/attachment.html>