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.
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
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
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
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
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 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
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
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
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
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
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
LEARN ABOUT DEBIAN
weatherrc
weatherrc(5) File Formats Manual weatherrc(5)
NAME
weatherrc - configuration file format for the weather(1) utility
DESCRIPTION
The weatherrc file format is intended to specify a set of aliases by which to group URIs for METAR station conditions and alert/forecast
zones, but other command-line options and flags for the weather utility can be specified as well. The file is organized as an INI-format
config, with the alias name in [] brackets and the associated parameter/value pairs on following lines. Parameters and their values are
separated by = or : characters. Multi-word values do not need quoting. These parameters are supported...
alert include local alert notices (possible values are False and True or 0 and 1)
atypes list of alert notification types to display (ex: tornado_warning,urgent_weather_message)
cache control all caching (possible values are False and True or 0 and 1)
cache_data
control retrieved data caching (possible values are False and True or 0 and 1)
cache_search
control search result caching (possible values are False and True or 0 and 1)
cacheage
duration in seconds to refresh cached data (ex: 900)
cachedir
directory for storing cached searches and data (ex: ~/.weather)
conditions
output current conditions (possible values are False and True or 0 and 1)
defargs
list of default command-line arguments (ex: avl,rdu)
forecast
include a local forecast (possible values are False and True or 0 and 1)
headers
list of conditions headers to display (ex: temperature,wind)
imperial
filter/convert conditions for US/UK units (possible values are False and True or 0 and 1)
metric filter/convert conditions for metric units (possible values are False and True or 0 and 1)
quiet skip preambles and don't indent (possible values are False and True or 0 and 1)
setpath
directory search path for correlation sets (ex: .:~/.weather)
verbose
show full decoded feeds (possible values are False and True or 0 and 1)
EXAMPLES
The following is an example ~/.weather/weatherrc defining a couple aliases named home and work to be displayed when running the utility
with no aliases specified...
[default]
defargs = home,work
[home]
description = Conditions and Forecast at Home
forecast = True
metar = http://weather.noaa.gov/pub/data/observations/metar/decoded/KRDU.TXT
zone_forecast = http://weather.noaa.gov/pub/data/forecasts/zone/nc/ncz041.txt
[work]
description = Conditions at Work
metar = http://weather.noaa.gov/pub/data/observations/metar/decoded/KGSO.TXT
Now if weather is invoked by itself on the command line, it will output conditions for home and work, and also a forecast for home only.
AUTHOR
Specification and manual written by Jeremy Stanley <fungi@yuggoth.org>.
SEE ALSO
weather(1)
2.0 2012-06-24 weatherrc(5)