Import 2 columns from 8 .csv files into pandas df (side by side) and write a new csv Post: 302944631

Sponsored Content

Top Forums Shell Programming and Scripting Import 2 columns from 8 .csv files into pandas df (side by side) and write a new csv Post 302944631 by Corona688 on Wednesday 20th of May 2015 06:30:21 PM

05-20-2015

Registered User

Ahhh. What you were calling column 8 I considered column 9.

I do not know python, and if I did, I probably wouldn't know all 5 modules you were using for this simple problem.

Code:

awk 'BEGIN {
        while(1)
        {
                A[ARGC]=0;
                for(N=1; (N<ARGC); N++)
                {
                        if((getline < ARGV[N]) <= 0) exit;
                        A[N]=$1;
                        A[ARGC] += $9;
                }

                A[ARGC]/=(ARGC-1);              P="";
                for(N=1; N<=ARGC; (N++) && (P="\t")) printf("%s%s", P, A[N]);
                printf("\n");
        }
}' a b c

5.42E+05        4.25E+03        1.30E+06        126000000
4.64E+04        4.47E+03        0.00E+00        593333
4.36E+04        5.12E+03        0.00E+00        635000
4.32E+04        4.32E+03        0.00E+00        570667
4.44E+04        4.64E+03        0.00E+00        767000
1.47E+05        5.03E+03        0.00E+00        3.39333e+06
1.81E+05        5.11E+03        0.00E+00        3.11333e+06
4.94E+05        5.79E+03        0.00E+00        6.54667e+06
4.79E+04        4.49E+03        0.00E+00        630667
4.51E+04        4.50E+03        0.00E+00        636000

$

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge 3 columns side by side

I know this is a stupid question for you guys! half day googling and i got nothing :( i have 3 variables/files, say: $X1 or file1: # there is one whitespace space after each line | 21 | 9 | 28 | 100 | 51 $X2 or file2: # there is one whitespace space...

2. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there......

3. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car...

4. Web Development

Cannot access Apache web server from Wan side, only Lan side.

I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network. Been through several setup tutorials so far, no dice still. For testing purposes I have...

5. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2:

6. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC

7. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to...

8. Shell Programming and Scripting

Combining two single column files side-by-side

Hi, I am looking for a sed/awk script to join two large (~300 M) single column files (one is sorted and the other is not sorted) side-by-side. I have a shell script but its taking ages to do the task so looking for an optimized fast solution. The two files look like: File1 (sorted) a1...

9. UNIX for Dummies Questions & Answers

Paste many files together side by side

Hi, Thank you for your help in advance :D. I have thousands of files like... file01 file02 file03 . . . file6324 I would like to paste every other file side by side so it looks like file01 file02 file03 file04 ...e.t.c file6323 file6324

10. Shell Programming and Scripting

Merging two text files side by side

Hi everyone, I need to merge two files side by side The files look something like this: HOSTNAME fishtornado-K52F 127.0.1.1 UPTIME 20:17:01 up 2:19, 3 users, load average: 0.00, 0.04, 0.05 DISK USAGE (Size/Used/Avail/Use%) 29G 6.5G 21G 25% RUN QUEUE PID COMMAND USER ...

LEARN ABOUT SUSE

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge 3 columns side by side

Discussion started by: amaulana

2. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Discussion started by: ks_reddy

3. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

Discussion started by: cajunfries

4. Web Development

Cannot access Apache web server from Wan side, only Lan side.

Discussion started by: davidmanvell