Light

ironhack-labs / lab-macros-intro Goto Github PK

0.0 2.0 349.0 850 KB

lab-macros-intro's Introduction

You are working as an analyst for an e-commerce platform. Your team receives data from a server about the activities of visitors on the website. The data is received at an interval of 12 hours from the servers and is recorded in the excel file in different sheets. Data recorded over 2 days is given to you in the file files_for_lab/server_data.xlsm.
The data downloaded from the servers is not in the desired format. We want to format the data and make it more presentable for your manager. Since the data is in different sheets, it would make more sense to create a macro. This is how the final data would look like: link to the image - Expected Output

Record a macro and apply it on all the sheets. Be careful if you have to use relative references or absolute reference in this case.
Go through the visual basic editor and remove the lines from the code that are not manipulating the data.

drhech vikasrathi1992 catarinamcbatista bcarrero sogunmola ernesto-yelamos louiscostes ferrazzolidicreddo cornettomlette leamartinez1411 danny88o macarenagortazar ahmed-abdelmoteleb josefin-b siloik sdbrugman ershovadina kjakubowska88 kymy91 kokeshi777 beto-amaral jw15667 felixley caaarov frmele vladtarverdov urgpan saranme robonejan mazim-co horacioe14 lupocordero lucaciceu polhervella johalruiz n-1983 deepdesh joangali1997 anastasia-mintz agathantavrazou elizabeth-sames callmeishmaelh inesrondeau lydiavanderputten amandasilvap hamzapektas renevans sergioaisolutions joriencaron enricocesaro gonzalo-zurita arektarnawski renejansen-in salwey ferran34160 joanabv saltmeyer agchesneau fyanli tekiniggemann minalborse filiklik ogooluwatomiwa iamlex006 ebourelly lidiabenitez m-perez-da eleni39 dalahrmann cargide marcelmb tomschouten emiliawoldan 1francisco1 felagund93 gvcarbajal myhaijay lydiaaboukhamis p-fuster dru0096 sorianom23 rbrt05 jordi-zaragoza mler76149 aaronpereira92 hectorfa17 levside pgatterbauer davidvazquezrios camille1992 dbsquare mbastcast abakos21 gebhard4 aggysamy sforbrig gbegara romeojab claraquer tgmiles

@sandrabosk
The picture of the expected output is missing from the lab, I found it on bitbucket though.

lab instructions refer to the final output being sorted by the client id but the image shows it is not.

suggest this step be removed

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.