Import csv into ArcGIS Pro

[ChuckChamberlain]

Hello, I'm currently trialing ArcGIS pro. I have some historical climate data I'm trying to import into ArcGIS, but I'm not sure exactly how to load in the data. Its in the csv format. I have attached a sample. Any suggestions on how to import this would be greatly appreciated. Thankyou

[JakeSkinner]

Hi Chuck,

Can you give some more background on what you would like to do with the data? 

For the ip46Pts.csv file, you can display these as points by adding the table to Pro > right-click on table > Display XY Data.

[ChuckChamberlain]

Thanks Jake,

Some additional info:

This contains 119 years of ensembled climate data (from 1981 to 2100)  for the given area.

1. The dataset includes daily precipitation Precipitation;
2. We generated climate data on each of the grids on and in the watershed 
3. Data are provided in probabilistic statistics output format, i.e., 10^th percentile, 50^th percentile and 90^th percentile; Obviously 50^th percentile results are the most likely 10^th and 90^th percentiles and two extremes with less possibility of occurrence.Looking to have the data displayed so that an anayst can look for trends over time in preciptiation, and look at different probabilitic outcomes (10%, 50%, or 90%).

thanks

[JakeSkinner]

Does the GRID_ID correspond to the POINT_ID?  For example, are you looking to create a join based off of these fields?

[ChuckChamberlain]

yes, exactly - i think I need to somehow join these fields

[JakeSkinner]

You can do this, but you need to format the precipitation table differently.  For example:

DailyPrecipitation	GRID_ID	Percentile	Pr (mm)
1/1/1981	1	10	2.3
1/1/1981	1	50	3.2
1/1/1981	1	90	6.1
2/1/1981	2	10	1.2

You can then join this table to the XY Data:

Joins and relates—ArcGIS Pro | ArcGIS Desktop 

[JayantaPoddar]

You could try Add x,y coordinate data as a layer—ArcGIS Pro | ArcGIS Desktop