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

well

In arcmap add file.csv and project it

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