Hi I have fakebook.csv as following:
F1(current date) F2(popularity) F3(name of book) F4(release date of book)
2006-06-21,6860,"Harry Potter",2006-12-31
2006-06-22,,"Harry Potter",2006-12-31
2006-06-23,7120,"Harry Potter",2006-12-31
2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Hi,
I want to know, how we find out if a column is having a numeric value or not.
For Example if we have a csv file as
ASDF,QWER,GHJK,123,FGHY,9876
GHTY,NVHR,WOPI,623,HFBS,5386
we need to find out if the 4th and 6th column has muneric value or not.
Thanks in advance
Keerthan (9 Replies)
Dear All,
I have this file tab delimited
A 1 12 22
B 3 34 33
C 55 9 32
A 12 81 71
D 11 1 66
E 455 4 2
B 89 4 3
I would like to make the average every column where the first column is the same, for example,
A 6,5 46,5 46,5
B 46,0 19,0 18,0
C 55,0 9,0 32,0
D 11,0 1,0 66,0... (8 Replies)
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
I have file1.txt
LBP298W2,300,-18,-115,-12,-105
LBP298W2,300,-18,-115,LBP298W3,300
LBP298W3,300,-18,-115,-12,-105---------- Post updated at 03:35 AM ---------- Previous update was at 03:34 AM ----------
i want to remove every line with non numeric value in column 5
expected result
... (4 Replies)
I have a file that looks like this:
id window BV
1 1 0.5
1 2 0.2
1 3 0.1
2 1 0.5
2 2 0.1
2 3 0.2
3 1 0.4
3 2 0.6
3 3 0.8
Using awk, how would I get the average BV for window 1? Output like this:
window avgBV
1 0.47
2 0.23 (10 Replies)
Hi,
My input file
Gene1 1
Gene1 2
Gene1 3
Gene1 0
Gene2 0
Gene2 0
Gene2 4
Gene2 8
Gene3 9
Gene3 9
Gene4 0
Condition:
If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging.
... (5 Replies)
From googling and reading man pages I figured out this sorts the first column by numeric values.
sort -g -k 1,1
Why does the -n option not work? The man pages were a bit confusing.
And what if I want to sort the second column numerically? I haven't been able to figure that out. The file... (7 Replies)
Hi All,
I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7
I tried
awk '{gsub("8","7",$35)}1' infile > outfile ----> not working
sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
LEARN ABOUT DEBIAN
cdk_position
cdk_position(3) Library Functions Manual cdk_position(3)NAME
cdk_position - curses widget positioning key-bindings
SYNOPSIS
Position methods for the Cdk widgets allow the user to move the widget around the screen via the cursor/keypad keys.
DESCRIPTION
The following key bindings can be used to move the widget around the screen.
+---------------------------------------------------------------+
|Key Action |
+---------------------------------------------------------------+
|Up Arrow Moves the widget up one row. |
|Down Arrow Moves the widget down one row. |
|Left Arrow Moves the widget left one column |
|Right Arrow Moves the widget right one column |
|1 Moves the widget down one row and left one |
| column. |
|2 Moves the widget down one row. |
|3 Moves the widget down one row and right one |
| column. |
|4 Moves the widget left one column |
|5 Centers the widget both vertically and hori- |
| zontally. |
|6 Moves the widget right one column |
|7 Moves the widget up one row and left one |
| column. |
|8 Moves the widget up one row. |
|9 Moves the widget up one row and right one |
| column. |
|t Moves the widget to the top of the screen. |
|b Moves the widget to the bottom of the |
| screen. |
|l Moves the widget to the left of the screen. |
|r Moves the widget to the right of the screen. |
|c Centers the widget between the left and |
| right of the window. |
|C Centers the widget between the top and bot- |
| tom of the window. |
|Escape Returns the widget to its original position. |
|Return Exits the function and leaves the wid- |
| getwhere it was. |
+---------------------------------------------------------------+
+---------------------------------------------------------------+
The numbers 0-9 are chosen to correspond to the numeric keypad on your terminal. Cdk does not handle the application mode keypad control
sequences, since those are not defined via terminfo. To use the numeric keypad you should ensure that it is in normal (or NumLock) mode.
SEE ALSO cdk(3), cdk_binding(3), cdk_display(3), cdk_screen(3)cdk_position(3)