ETL project with C language
$250-750 USD
Paid on delivery
The project will need to be done in C# language only no C++ or other language please. I can send full description of this project.
The objectives of this assignment are to demonstrate proficiency in file I/O, data structures, and data transformation using C language resources. Specifically, you will read in data from a text file, use that data to populate a data structure, and print that data to STDOUT by accessing the newly populated structure.
The first part of ETL is extraction. The filename of a text file will be passed to your program via the command line. The data contained in that file is to be read into memory (i.e., extracted). Your program will be compiled and run on Eustis using the following commands:
gcc -o etl hw1etl.c
./etl inputFile
It is entirely possible that the input file either does not exist or is not where it is supposed to be. In such an event, your program should print an error message to STDERR that indicates which file is missing, then your program should exit safely. Use the following format for your error message (fileName should display the actual name of the missing file):
etl ERROR: File “fileName” not found.
The input file is in CSV (comma separated values) format where each line contains the data for one airport and the fields are as printed below. Note that these fields vary in size and content. Some fields may even be empty. Also note that the data for some of the fields are a melange of types. Specifically, the FAA Site Number and both latitude and longitude contain numbers, punctuation, and text.
1.2 Transformation
The second part of ETL is transformation. A list of comma separated values is convenient for text files, but it is far less convenient in memory. Once the data for a single airport has been read into a buffer, you will need to parse the buffer based on the commas between the data fields. The parsed data will then be used to populate a structure of the type struct airPdata (i.e. the data has been transformed from CSV to a data structure). The format of airPdata, shown below, will be defined in airPdata.h. Note that the airPdata structure uses the same names as the input file’s Field Names (See Table 1 on page 2), though not all of the Field Names are used.
typedef struct airPdata{
char *siteNumber; //FAA Site Number
char *LocID; //Airport’s ‘‘Short Name’’, \textit{e.g.} MCO
char *fieldName; //Airport Name
char *city; //Associated City
char *state; //State
char *latitude; //Latitude
char *longitude; //Longitude
char controlTower;//Control Tower, this is a single character (Y/N)
} airPdata;
Remember, some of these fields will be of differing lengths for each airport. When you allocate memory structure’s fields, you can assume that no entry will be longer than 50 characters (plus 1 character for the terminating NULL).
1.3 Loading
Finally, the third part of ETL is loading. With the data now in an airPdata structure it can be easily accessed by functions and/or other programs (i.e., loaded). For this assignment, you will use pass the airPdata structure to a function ( PrintData(airPdata airport) ) that will print the data to STDOUT (aka the console). Before calling PrintData for the first time, make sure you print a header line that names each column. Specifically, use the following two lines of code:
printf("%-12s %-11s %-42s %-34s %-3s %-15s %-16s Towernn", "FAA Site", "Short Name", "Airport Name", "City", "ST", "Latitude", "Longitude");
printf("%-12s %-11s %-42s %-34s %-3s %-15s %-16s =====nn", "========", "==========", "============", "====", "==", "========", "=========");
This program will need to be done with C language only, not C# or C++. I have made a confusion in the description.
Project ID: #15344797
About the project
19 freelancers are bidding on average $378 for this job
Hello, I am expert with C and C++ since > 20 years ago. I should be the guy for any task like this. Habilidades y experiencia relevante c, c++ Htos propuestos $250 USD - the job
Hello. i have understood your project. i can easily do this task as i have an extensive experience in C programming. we can have a chat about it. thanks Relevant Skills and Experience C programming Proposed Milestone More
Hello Your description is detailed so I can tell that I can handle effectively all the requirements using C (and only C!!) I offer the lowest bid because I estimate it to be a work of 3-4 days Relevant Skills and Expe More
hey mate. checked your requirements. are you sure it is c#? would surely help you get a good grade.
hi. i read the description and it sounds not so hard to do. Relevant Skills and Experience i know c good enough for this project Proposed Milestones $250 USD - code i will need sample .csv input file
HI, I am software engineer, i have done major part of software development in VB.net. i am new to freelancer. i have used C# in Visual Studio in past for front end software development. Relevant Skills and Experience More
I will do it in as fast as possible, and with best quality Relevant Skills and Experience I've already made a lot of C projects with different purposes Proposed Milestones $250 USD - finish the task
ETL & business Intelligence Expert are here. We have a team develop different ETL's using SSIS, Pentaho etc. We have deliver many ETL's belong to different domain. Relevant Skills and Experience We have recently deliv More