You might find it easier for your to handle data in a CSV file rather than in a GRIB file. This how-to shows you how to do that using ECMWF's ecCodes. You are expected to have it installed on a Linux machine before you continue. You should are also recommended to add ecCodes' "bin" directory to your PATH.
...
- Download 2m temperature from the Copernicus Climate Change Service (C3S)'s Climate Data Store (CDS) and save the data as file t2m_20000801.grib. In this example, selections are set as below:
- Dataset: ERA5 hourly data on single levels from 2000 to 2017 (you may see different years as new data is released)
- Parameter: 2m temperature
- Product type: Reanalysis
- Year: 2000
- Month: August
- Day: 01
- Time: 06:00, 12:00 and 18:00
- Format: GRIB
- Check the GRIB file by issuing the "grib_ls -P time t2m_20000801.grib", you should see three GRIB messages in the file at three different times: 600, 1200, 1800. Remember three time values were selected in step 1.
Say I want to extract lat, lon, 2t (2m temperature) at time = 12:00 from the GRIB file. Run "grib_get_data -w time=1200 t2m_20000801.grib > t2m_20000801.csv" and you will get a file containing data like below:
Code Block language bash Latitude, Longitude, Value 90.000 0.000 2.7346786499e+02 90.000 0.250 2.7346786499e+02 90.000 0.500 2.7346786499e+02 90.000 0.750 2.7346786499e+02 ...
- Remove two commas in the header line of the CSV file, you will be ready to import it in Excel.Make t2m_20000801.csv a proper CSV file
Info |
---|
If you have CDS API and ecCodes (with its Python interface) installed, you can do the above by writing up a Python script. |
...