1

I get data in my job which contains datetime, Temperature, Current(mA), Brake release. This data is of a crane motor. In one day there are about 80k-100k rows in excel generated by the tags.

I have to make a visulization where the datetime, current, temperature, and releasing of the brakes(0&1 only) are shown for every second and it should be live and the graph must have arrows and zoom in with functions that if I click in one point it takes me to the data.

It could be on excel, jupyter, R studio or any visualization tools like tableau, looker etc.

This is the first query in my newly joined job, I am very frustrated because I have tried several things but it just won't happen.

People in my office has done this same thing but the data aggregates for maximum/minimum and only shows on hourly basis.

Tried line chart in excel and bar plot in jupyter but won't happen.

James Z
  • 12,209
  • 10
  • 24
  • 44
Mohammad Zeeshan Ali
  • 11
  • 1
  • 1
    You need a mentor. Talk to your boss about arranging this. – ravenspoint Mar 28 '23 at 20:41
  • I am alone and I will be the only source they have for these kind of work, so if you can please answer it. – Mohammad Zeeshan Ali Mar 29 '23 at 08:33
  • "please answer it." There is no it. You have asked many questions all at once. "excel, jupyter, R studio or any visualization tools like tableau, looker etc." Choose one and ask a question about that one. – ravenspoint Mar 29 '23 at 13:27
  • Answer as per your expertise, If you are good in excel or google sheets and the results are achievable than go ahead. Or else do it in python/R. If that's okay with you. – Mohammad Zeeshan Ali Mar 30 '23 at 19:50
  • You are the only person who knows enough about your situation to select the tools that you can use and maintain. That is why questions asking for recommendations are disallowed on stackoverflow. Select what tool you want to use, tag your question with the name of the tool. Then experts on that tool will notice your question and be able to help you. – ravenspoint Mar 30 '23 at 19:57

0 Answers0