Sponsored Content
Top Forums Shell Programming and Scripting NWS CLI data Coverting to .CSV file Post 302883393 by Cambium27 on Monday 13th of January 2014 10:24:48 PM
Old 01-13-2014
NWS CLI data Coverting to .CSV file

Hi everyone, I found this forum through a google search I'm hoping someone can help me. I am so clueless on coding stuff so bare with me.

I need to write a script/program to convert the snowfall data to a .CSV file. But I guess it doesn't end there.

I'm looking to grab snowfall totals and departures from the NWS CLI data for all climo sites reporting it and enter them into excel. Just those numbers.

I did this manually for the climo sites with the CLI reports.. I'm looking for a way to automatically get them into excel.

Here's the manual version so you have an idea what data I'm talking about.

Image


Thanks so much!

---------- Post updated at 10:24 PM ---------- Previous update was at 10:23 PM ----------

I can't post links until I have 5 posts.

I don't know where to find the raw data from NWS, what I use is the climate links for each NWS office like this one in Buffalo. (just add www & eliminate space)
nws.noaa .gov/climate/index.php?wfo=buf

Just click Go and you'll see the snowfall data.

Or use this link to see the entire NWS Offices listed on same page. Maybe that might help? nws.noaa .gov/view/validProds.php?prod=CLI
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused: (3 Replies)
Discussion started by: Csmani
3 Replies

2. Programming

coverting html data to text in 'c'

hi, iam reading the webpage using curl socket. so iam geting the data in html format so how can convert html data to text data ,so i can move forward. thank u, sree (3 Replies)
Discussion started by: phani_sree
3 Replies

3. Shell Programming and Scripting

extracting data from a .csv file

I have a .csv file equipment,bandtype abc,aws def,mmds ghi,umts jkl,mmds I can get the equipment from `hostname`. In my script i want to check what is the hostname. then see if it exists in the.csv file. if it does then i want to store the second parameter(bandtype) for the corresponding... (3 Replies)
Discussion started by: lassimanji
3 Replies

4. Linux

Coverting a log file into XML

ID -------CODE-------DATE-------URL I have a log file with entries like this. The file has about 6 lakhs record and the size is about 42MB. I need to covert them into a XML file like <ID></ID> <CODE></CODE> <DATE></DATE> <URL></URL> I have done a logic for this and successfully done.... (0 Replies)
Discussion started by: arunkumar.in
0 Replies

5. Shell Programming and Scripting

I want to append data to same .csv file.

I have a script which has to be scheduled to run 3 times a day. My script picks the required fields from logfile and stores the data in a.csv file. Sample data. my logfile contain: 0097A,0374D,100903,1519,00000606191 0097A,C88RA,100903,0724,00000606105 So the output of first execution... (3 Replies)
Discussion started by: shrima.pratima
3 Replies

6. Shell Programming and Scripting

How to extract data from csv file

Hello everybody, Here is my problem, I don't know anything about shell programming and my boss is actually asking me to develop a shell script in order to get values in a csv file from a specific date. Here is a sample of the csv file : Date;Enchaînement;Titre;Libellé ;calendrier;Heure début;Heure... (11 Replies)
Discussion started by: freyr
11 Replies

7. Shell Programming and Scripting

Fetching data from .csv file

Hi Experts, I have created a table with columns as empname,empid,phone,shiftname. Now I am having a .csv file format which contains the shift datas of the employees. I have to fetch this file and compare with the table I created to send an alert to the specified user. (2 Replies)
Discussion started by: micky3112
2 Replies

8. Shell Programming and Scripting

Data Manipulation on a .csv file

Hallo Friends, I need you help. My file has 5000 or so lines and currently looks like below(sample). Service Type,Origin,Destination,Rate Per Minute,Minimum Charge,Time Based Rate,Time Based From Day,Time Based To Day,Time Based From Time,Time Based To Time,Destination Prefix List,, VoIS... (3 Replies)
Discussion started by: kekanap
3 Replies

9. Shell Programming and Scripting

CSV file data extraction

Hi I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it. IN301330/00001 pvavan kumar limited xyz@ttccpp.com IN302148/00002 PRECIOUS SECURITIES (P) LTD viash@yahoo.co.in IN300239/00000 CENTRE india... (8 Replies)
Discussion started by: nanduri
8 Replies

10. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
WMWEATHER(1)							   Version 2.4.5						      WMWEATHER(1)

NAME
wmweather - dockable weather monitor SYNOPSIS
wmweather -s <4-char ICAO location indicator> [options] DESCRIPTION
wmweather monitors local weather conditions: temperature, dew point, pressure, humidity and wind direction and speed. The user needs to specify a 4-character `ICAO location indicator'. The standardized METAR station designations and current weather reports are designed for use by the aviation community. Since most major cities have at least one airport, there is usually one or more METAR stations in a given city. You--obviously--need to be connected to the internet and you also need to have libcurl installed. wmweather will then attempt to download the latest METAR report for the station of your choice from the National Weather Sevice run by NOAA. You can toggle back and forth between imperial and metric units, i.e. between degrees Fahrenheit, inches of Mercury, and miles per hour--and--degrees Celsius, hectoPascal, and kilometers per hour. A middle click will do this. Also, a left click will bring up the fully decoded METAR report in xmessage. And a right click will force an immediate update, i.e. wmweather will attempt to grab weather information. OPTIONS
-s id, --station=id This option tells wmweather which METAR station to show data for. id can be any four-letter ICAO location indicator, which can be found at http://www.nws.noaa.gov/tg/siteloc.shtml. -c, --compat Switch into compatibility mode. The old monitor style will be used, default metric pressure units are millimeters of Mercury instead of hectoPascal, and the colorization options are enabled. When the time turns red, this means that the weather report is older than 24 hours. When the wind speed turns red, this means that the wind is gusty and the listed value is an average only. Similarly, a red direction indicates a variable wind direction and the value given is the average direction. The symbolic link wmWeather is func- tionally equivalent to wmweather --compat. -d [@]min, --delay=[@]min Set the time (in minutes) between updates, default is 15 minutes. Use @ to specify minutes past the hour. -m, --metric Display metric values: temperatures in degrees Celsius rather than degrees Fahrenheit, pressure in hectoPascal rather than inches of Mercury, and wind speed in kilometers per hour rather than miles per hour. This option can be toggled at runtime using a middle click. -w, --chill, -W Display wind chill--if available--instead of dew point temperature. -e, --heat Display wind heat index--if available--instead of temperature. -b, --beaufort Display wind speed on the `Beaufort scale'. -n, --knots Display wind speed in units of knots, i.e. sea miles per hour. -u, --utc Display update time in UTC instead of localtime. This is equivalent to --time=+0000. -t offset, --time=offset Convert update time according to (RFC 822 compliant) time offset rather than to localtime, e.g. --time=+0100 for MET. -x host[:port], --proxy=host[:port] Proxy specification, this option is passed to libcurl. -U username[:password], --proxy-user=username[:password] Proxy authentication, this option is passed to libcurl. Please don't specify this option, use the file ~/.netrc for authentication instead. --lcd Use LCD style display. --display=id Set the display to use, e.g. --display=:0.0. --geometry=pos Set the position of the dock app. Note that the size (64x64) is hard-coded and cannot be changed. -h, --help Display a list of command-line options. -v, --version Display the program version. -a, --hPa When toggled to metric, display pressure in units of hectoPascals, i.e. milliBars. -k, --kPa When toggled to metric, display pressure in units of kiloPascals. -g, --mmHg When toggled to metric, display pressure in units of millimeters of Mercury. -p, --mps When toggled to metric, display wind speed in units of meters per second. --bc=color When toggled to compatibility mode, set the background color (#8e8e69 is LCD-ish). --lc=color When toggled to compatibility mode, set the color of the labels, e.g. --lc=red or --lc=salmon or --lc=#4523ff. --dc=color When toggled to compatibility mode, set the color of the data entries. --wgc=color When toggled to compatibility mode, set the gusty-wind/variable-direction color. The wind speed indicator will turn this color when the wind speed is gusty. The value shown in this case is the average speed. Similarly, the wind direction indicator with change to this color when the wind direction is variable. The value shown in this case is the average direction. --tc=color When toggled to compatibility mode, set the color of the ICAO location indicator and update time header. FILES
/etc/wmweather.conf The system-wide configuration file. Specify one long option per line, e.g. station=EDDC or metric. Whitespace, empty lines, and lines beginning with a # will be ignored. ~/.wmweather/config The user configuration file. ~/.wmweather/???? These files contain the latest downloaded weather records in decoded METAR format. ~/.netrc These file contains authentication information and should be used in preference to --proxy-user. ENVIRONMENT
http_proxy The HTTP proxy to be used, see also --proxy. SEE ALSO
netrc(5) To find out more about NOAA's National Weather Service, have a look at http://www.nws.noaa.gov/. BUGS
Please report any bugs to <martin@godisch.de>. Debian users are encouraged to use the Debian Bug Tracking System at http://bugs.debian.org/wmweather. AUTHORS
Version 1: Michael G. Henderson <mghenderson@lanl.gov> Version 2: Martin A. Godisch <martin@godisch.de> Contributors: Athanasius, Pablo Castellazzi, Avtar Gill, Adam Lackorzynski, Jon Larabee, Jordi Mallach, Paul Martin, HIROSE Masaaki, Michael Potters The Debian Project July 2009 WMWEATHER(1)
All times are GMT -4. The time now is 10:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy