Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
I've got two large csv text table files with different number of columns each.
I have to compare them based on first two columns and create resulting file
that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Hello everyone!!
I am not completely new to shell script but I havent been able to find the answer to my problem and I'm sure there are some smart brains here up for the challenge :D.
I have several CSV files that I need to combine into one, but I also need to know where each row came from.... (7 Replies)
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
I am running an ISQL command on Sybase DB and getting output of a query in an CSV file.
The issue is that all the data comes in to the same column, i want them to be separated in different columns.
SQL_COMMAND=command.sql
file=file.txt
formatFile=formatFile.txt
report=report.csv
echo... (1 Reply)
I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file
Command that Ive been using... (6 Replies)
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
1.csv contains following column-
Empid code loc port
101 A xy 01
102 B zx 78
103 A cg 12
104 G xy 78
2.csv contains follwing data-
Empid code loc port
101 A gf 01
102 B zx 78
103 C cg 32
104 ... (1 Reply)
Discussion started by: rishabh
1 Replies
LEARN ABOUT DEBIAN
numm.spectral-analysis
spectral-analysis(7) Numm Tutorials spectral-analysis(7)NAME
spectral analysis - perform realtime spectral analysis
SYNOPSIS
numm-run FILE
DESCRIPTION
Frequency makes for a meaningful description of many audio signals. We can use numpy's fourier analysis to compute spectra from the micro-
phone and display the results visually. We will break down the process into smaller parts: baby steps...
First, create and save a skeletal file that moves a line across the screen:
idx = 0
def video_out(a):
global idx
a[:,idx] = 255
idx = (idx + 1) % a.shape[1]
def audio_in(a):
pass
Save this snippet and run it with numm-run.
We will use the numpy.fft module for our analysis. First we define a function to get a particular frequency from the fourier transform:
import numpy as np
def get_freq(fourier, frequency):
freqs = np.fft.fftfreq(len(fourier), 1/44100.0)
nearest = (abs(freqs - frequency)).argmin()
return abs(fourier[nearest])
Next, we hook up this function to audio input from the microphone. A frequency bin is chosen on a log scale for each row on the screen to
display a spectogram. In total:
import numpy as np
idx = 0
recent_audio = np.zeros(4096, np.int16)
recent_video = np.zeros((240,320,3), np.uint8)
freq_bins = np.exp2(np.linspace(np.log2(27000),np.log2(27),240))
def get_freq(fourier, frequency):
freqs = np.fft.fftfreq(len(fourier), 1/44100.0)
nearest = (abs(freqs - frequency)).argmin()
return abs(fourier[nearest])
def video_out(a):
global idx
fourier=np.fft.fft(recent_audio)
values =np.array([get_freq(fourier,X) for X in freq_bins])
recent_video[:,idx,1] = (values/10000).clip(0,255)
idx = (idx + 1) % a.shape[1]
a[:] = np.roll(recent_video, -idx, axis=1)
def audio_in(a):
recent_audio[:] = np.roll(recent_audio, len(a))
recent_audio[:len(a)] = a.mean(axis=1)
SEE ALSO numm-run(1), numm.getting-started(7), numm.one-bit-instrument(7)numm February 2012 spectral-analysis(7)