i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
2 4894i have some csv files in a directory which have sub-directories also. now how can i merge all .csv files in to one with a single header. for example: have some 4 files. 1.csv--------name,age,sal abc,25,4000 2.csv--------name,age,sal vgd,32,3500 3.csv--------name,age,sal hfg,20,5000 4.csv--------name,age,sal asd,15,2000 now my output file should be like 5.csv----------name,age,sal abc,25,4000 vgd,32,3500 hfg,20,5000 asd,15,2000 and please explain the code for me. as i am new to scripting. thank you in advance
1828What is the more accurate formula to convert wet concrete to dry aggregate instead of the 54% method?
2039Post New Tech Mahindra Interview Questions
Why singleton class is sealed in c#?
How many public class files are possible to define in Scala source file?
Are hash tables ordered?
Let us say you have a collection of multiple maps in cics. So if you are asked to determine the exact storage space that is available in a symbolicmap, then how will you compute it?
Can you sort a to z in word?
How many secondary indexes can we create in a table?
What is partial data sandbox?
Draw the circuit diagram of 1φ capacitor commutated current source inverter and explain its operation with equivalent circuits for different modes and necessary wave forms?
What keyword allows us to implement abstraction better in flex? : adobe flex action script
What is joomla best used for?
What is an asynchronous api?
Should a main method be compulsorily declared in all java classes?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Why does one remove or add nodes in a Hadoop cluster frequently?
What is bagging and boosting in Machine Learning?