Corporate spend data analytics project


I have a very large data file of corporate spend data for a large manufacturing company. It is 14 million lines of data in a single, 6GB CSV file. I need to merge / enrich the data with certain more detailed attributes from some separate files I have. In the large file -- many of the columns provide a unique ID number, such as "vendor ID number," and I then need to find those numbers in the "vendor ID master list" file, and populate the vendor data back into new columns in the large original file. Then, once the large file is fully filled out with the supporting data all merged in -- we need to create various analyses and visualizations of the data.

Keyword: Data Analysis

Financial Analysis Data Mining Microsoft Excel Python

 

Technician, Technical Assistant

-Always responsible for performing each assigned task within the given time period. -Able to work in a group and always provide the best cooperation to produce the best work results. -Has no problem in listening and receiving instructions from superiors. -Experts in dat...

View Job
Financial Audit/Ongoing Cash flow advising

My finances are a mess. I had a former business partner who used to handle bookkeeping and general financial management but they were not skilled in finance and I have no set systems or processes. I use quickbooks. I am a small business 3 full time contractors and mysel...

View Job
Capture and Send packets on Linux Game

Software Development Request: Game Monster Detection and Interaction Application Project Overview: The objective is to develop an application capable of detecting and interacting with monsters in the game by sending specific packets to the game server. The application w...

View Job