I want to read the IMD data in ARCMAP or QGIS so that further analysis can be done. Please see the file attached as it indicates how IMD rainfall data is stored in .TXT format.
Hello Nikhil Raj Deep,
In QGIS you could make use of the Delimited Text importing tool under the Data Importing dialog. I am not familiar with IMD rainfall data, but assuming it had some geographical data associated with with (LAT or LON columns) you could even nicely plot it over a map. I did some quick googling and have found this quick reference for a relatively similar question in gis.stackexchange:
https://gis.stackexchange.com/questions/273143/adding-delimited-text-layer-in-qgis
Could you give us more information about the available columns in your dataset or what are your intentions with it? Maybe we could elaborate more on the answare.
Please, let me know if it worked for you and good luck.
Best regards,
David
Dear Nikhil
This dara is better explored in linux environmant using Grads you can use a GUI of grads and extract and explore the data on windows system the data is in gridded format.
please find the text format of IMD rainfall data. I would be grateful and thankful if there is any code in MATLAB, Python or R to export the data in GIS packages.
Open this data with excel, then save it as an .xlsx format.
Then use
xlsread('imdrainfall.xlsx');
in MATLAB to read the data. After that, you can easily do any analysis with it in MATLAB.
I already read the data in matlab. Now i want to subset the data based on date and then by its latitude , longitude and value. When you look on the data, the first column specify date and since data is in matrix form thus it has indexing as latitude and longitude. I want to store data in three columns with each date Bijay Kumar Guha
a1=xlsread('imdrainfall.xlsx');
lat=a1(2:130,2);
lon=a1(1,2:134);
data=a1(2:130,3:135);
A1=[];
for i=1:129
for j=1:133
A1=[A1; lat(i) lon(j) data(i,j)];
end
end
Run this code. A1 is your desired format for the 1st date only. You can do the same for other days.
Best
- Badges
- Science topic