I have data range (lets say) from 0.1 to 1.0 and I want to divide it into three different ranges: low, medium and high values. Is there any automatic method to select these ranges?
Yes, you can. Most of the GIS/RS software should do it. If you have access to Arc GIS you can use Arc Map and categorize the data (classification). Thanks.
Dear Brother thanks for your reply. I want to let you know that data is in text format (or just column of Excel). Can you please tell me in steps how to do it using Arc Map (which tool I need to use it).
Thank you.
Try it in R, it would be a matter of few seconds:
I am assuming that your excel sheet with the data has 35 rows and 4 columns (arbitrary), column 'category' contains the values (0.1-1.0) based on which you want to categorize your data and the file is called 'data.xlsx'. Try this:
library(rJava)
library(xlsx)
# if you are new to R, both packages need to be installed first with install.packages()
command, e.g. install.packages("rJava"). Please visit http://www.r-project.org/ for details
setwd("your directory which contains the data")
# e.g. C:/Desktop, note that if you are a Windows OS user, you need to change '\' into '/'.
data
Dear Avit thanks for your comment. As I understand from last few lines of your code that I have to define the ranges of low, medium and high values from the data as you did. This can also be done in Excel. But, I want to know any tool that can these ranges automatically based on the nature of the data. The data is not continues from 0.1 to 1.0 but random values
Not necessarily, you can create natural or such breaks in the data. In the package 'classInt', 'classIntervals' function can create 10 different types of breaks in the random variables. Afterwards you just need to change the which criteria according to the breaks. Hope that helps.
I don't have any experience of R. If you please guide me how to install and work on it on Windows OS then it will be great. Thanks very much!
Installation in fairly easy, go to the r-project page that I mentioned before and under the download tab choose the CRAN mirror of your country zone. I have already demonstrated how to install packages, you may also have a look at my publications if you are interested: https://www.researchgate.net/profile/Avit_Bhowmik/contributions/?ev=prf_act. Let me know if you get any trouble.
- Badges
- Science topic
- Similar topics
- Geoscience
- Remote Sensing