02-08-2020
I did not see your reply with the alternate code. Thanks for that. As far as the "algorithm", lol, there really is nothing more to it. The actual file does not contain student grade data but it does have names, categories and title and then a numerical column which needs to be averaged for all titles and then a string value given based on avg per name, as you have helped me with here.
I actually have another issue. Posting it here for reference but will start a new thread and give a bit of back story on it, but I need to do the same EXACT thing, only now in Perl.... Like I said, I will explain more in a new thread, so this one can be closed properly.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to find the top N entries for a certain field based on the values of another field.
For example if N=3, we want the 3 best values for each entry:
Entry1 ||| 100
Entry1 ||| 95
Entry1 ||| 30
Entry1 ||| 80
Entry1 ||| 50
Entry2 ||| 40
Entry2 ||| 20
Entry2 ||| 10
Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies
2. UNIX for Dummies Questions & Answers
So, I need to do some summing. I have an Apache log file with the following as a typical line:
127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326
Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a... (7 Replies)
Discussion started by: treesloth
7 Replies
3. Shell Programming and Scripting
Hi
i am new to scripting. i have a file file.dat with content as :
CONTENT_STORAGE PERCENTAGE FLAG:
/storage_01 64% 0
/storage_02 17% 1
I need to update the value of FLAG for a particular CONTENT_STORAGE value
I have written the following code
#!/bin/sh
threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies
4. Shell Programming and Scripting
Hi everybody,
I'm trying to replace the $98 field with "T" if the last field (108th) is T
I've tried
awk 'BEGIN{OFS=FS="|"} {if ($108=="T")sub($98,"T"); print}' test.txt
but that doesn't do anything
also tried
awk 'BEGIN{OFS=FS="|"}{ /*T.$/ sub($98,"T")} { print}' test.txt
but... (2 Replies)
Discussion started by: jghi123
2 Replies
5. Shell Programming and Scripting
I am trying to confirm the counts from another code and tried the below awk, but the syntax is incorrect. Basically, outputting the counts of each condition in $8. Thank you :)
awk '$8==/TYPE=snp/ /TYPE=ins/ /TYPE=del/ {count++} END{print count}'... (6 Replies)
Discussion started by: cmccabe
6 Replies
6. Shell Programming and Scripting
In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of
HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=.
Hopefully the awk is a start but I... (2 Replies)
Discussion started by: cmccabe
2 Replies
7. Shell Programming and Scripting
I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines.
If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies
8. Shell Programming and Scripting
In the perl below, which does execute, I am having trouble with the else in Rule 3. The digit in f{8} is extracted and used to update f accordinly along with the value in f.
There can be either - * or + before the number that is extracted but the same logic applies, that is if the value is greater... (5 Replies)
Discussion started by: cmccabe
5 Replies
9. Shell Programming and Scripting
In the awk below I am trying to copy the entire contents of $6 there may be multiple values seperated by a ;, to $8, if $8 is . (lines 1 and 3 are examples). If that condition $8 is not . (line2 is an example) then that line is skipped and printed as is. The awk does execute but prints the output... (3 Replies)
Discussion started by: cmccabe
3 Replies
10. UNIX for Beginners Questions & Answers
Request your help to change the field color based on condition , if it is otherthan 0. using html in unix.
Here is my condition
for(i=1;i<=NF;i++)
{
print "<td> "$i"</td>
}
Please use CODE tags when displaying sample input, output, and code segments. (17 Replies)
Discussion started by: CatchMe
17 Replies
LEARN ABOUT DEBIAN
parse::mediawikidump::page
Parse::MediaWikiDump::page(3pm) User Contributed Perl Documentation Parse::MediaWikiDump::page(3pm)
NAME
Parse::MediaWikiDump::page - Object representing a specific revision of a MediaWiki page
ABOUT
This object is returned from the "next" method of Parse::MediaWikiDump::Pages and Parse::MediaWikiDump::Revisions. You most likely will not
be creating instances of this particular object yourself instead you use this object to access the information about a page in a MediaWiki
instance.
SYNOPSIS
$pages = Parse::MediaWikiDump::Pages->new('pages-articles.xml');
#get all the records from the dump files, one record at a time
while(defined($page = $pages->next)) {
print "title '", $page->title, "' id ", $page->id, "
";
}
STATUS
This software is being RETIRED - MediaWiki::DumpFile is the official successor to Parse::MediaWikiDump and includes a compatibility library
called MediaWiki::DumpFile::Compat that is 100% API compatible and is a near perfect standin for this module. It is faster in all instances
where it counts and is actively maintained. Any undocumented deviation of MediaWiki::DumpFile::Compat from Parse::MediaWikiDump is
considered a bug and will be fixed.
METHODS
$page->redirect
Returns an empty string (such as '') for the main namespace or a string containing the name of the namespace.
$page->categories
Returns a reference to an array that contains a list of categories or undef if there are no categories. This method does not understand
templates and may not return all the categories the article actually belongs in.
$page->title
Returns a string of the full article title including the namespace if present
$page->namespace
Returns a string of the namespace of the article or an empty string if the article is in the default namespace
$page->id
Returns a number that is the id for the page in the MediaWiki instance
$page->revision_id
Returns a number that is the revision id for the page in the MediaWiki instance
$page->timestamp
Returns a string in the following format: 2005-07-09T18:41:10Z
$page->username
Returns a string of the username responsible for this specific revision of the article or undef if the editor was anonymous
$page->userid
Returns a number that is the id for the user returned by $page->username or undef if the editor was anonymous
$page->userip
Returns a string of the IP of the editor if the edit was anonymous or undef otherwise
$page->minor
Returns 1 if this article was flaged as a minor edit otherwise returns 0
$page->text
Returns a reference to a string that contains the article title text
perl v5.10.1 2010-12-05 Parse::MediaWikiDump::page(3pm)