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

Tue Jan 18 18:05:18 PST 2022

Hi,

Probably but this would be a Grass request.  

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 18 janv. 2022 à 20:14, Ari Meyer <ari.meyer at gmail.com> a écrit :
> 
> 
> 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: 
>>>> 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.
>>>> 
>>>> 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
>>>> 
>>>> 
>>>> 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/40d16033/attachment-0001.html>