Как построить диаграмму Ганта из нескольких столбцов данныхPython

Программы на Python
Ответить Пред. темаСлед. тема
Anonymous
 Как построить диаграмму Ганта из нескольких столбцов данных

Сообщение Anonymous »

У меня есть главный файл CSV, который содержит подробную информацию обо всех продуктах в нашем репозитории, а также соответствующие данные о времени (Time_In и Time_Out). Я прочитал CSV-файл в фрейм данных с помощью pandas.
Может кто-нибудь сказать мне, как я могу построить график деталей всех продуктов (Product_A1,...,Product_A7) в зависимости от их соответствующего Time_In Подробности и Time_out в одном графике с использованием Python.
Мне нужно что-то вроде этого.
< / p > < b r / > < h 3 > < c o d e > m a s t e r _ d f . c s v < / к о д > < / h 3 > < b r / > < p r e c l a s s = " l a n g - n o n e P r e t t y p r i n t - o v e r r i d e " > < c o d e > D a t e _ A 1 , P r o d u c t _ A 1 , T I m e _ I n _ A 1 , T I m e _ o u t _ A 1 , D a t e _ A 2 , P r o d u c t _ A 2 , T I m e _ I n _ A 2 , T I m e _ o u t _ A 2 , D a t e _ A 3 , P r o d u c t _ A 3 , T I m e _ I n _ A 3 , T I m e _ o u t _ A 3 , D a t e _ A 4 , P r o d u c t _ A 4 , T I m e _ I n _ A 4 , T I m e _ o u t _ A 4 , D a t e _ A 5 , P r o d u c t _ A 5 , T I m e _ I n _ A 5 , T I m e _ o u t _ A 5 , D a t e _ A 6 , P r o d u c t _ A 6 , T I m e _ I n _ A 6 , T I m e _ o u t _ A 6 , D a t e _ A 7 , P r o d u c t _ A 7 , T I m e _ I n _ A 7 , T I m e _ o u t _ A 7 < b r / > 0 7 - 0 6 - 2 0 2 3 , A 1 , 0 0 : 0 0 : 0 0 , 0 0 : 4 5 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 2 , 0 0 : 0 0 : 0 0 , 0 1 : 0 3 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 3 , 0 0 : 0 0 : 0 0 , 0 0 : 3 0 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 4 , 0 0 : 0 0 : 0 0 , 0 0 : 1 5 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 5 , 0 0 : 0 0 : 0 0 , 0 0 : 3 3 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 6 , 0 0 : 0 0 : 0 0 , 0 0 : 4 8 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 7 , 0 4 : 0 0 : 0 0 , 0 5 : 0 3 : 0 0 < b r / > 0 7 - 0 6 - 2 0 2 3 , A 1 , 0 0 : 4 8 : 0 0 , 0 1 : 0 0 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 2 , 0 1 : 0 6 : 0 0 , 0 1 : 1 8 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 3 , 0 0 : 3 3 : 0 0 , 0 3 : 3 3 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 4 , 0 0 : 1 8 : 0 0 , 0 2 : 1 5 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 5 , 0 0 : 3 6 : 0 0 , 0 2 : 1 8 : 0 0 , 0 7 - 0 6 - 2 0 2 3 , A 6 , 0 0 : 5 1 : 0 0 , 0 1 : 06:00,07-06-2023,A7,05:06:00,06:21:00
07-06-2023,A1,01:03:00,01:15:00,07-06-2023,A2,01:21:00,02:45:00,07-06-2023,A3,03:36:00,04:30:00,07-06-2023,A4,02:18:00,03:18:00,07-06-2023,A5,02:21:00,03:36:00,07-06-2023,A6,01:09:00,01:21:00,07-06-2023,A7,06:24:00,07:03:00
07-06-2023,A1,01:18:00,01:30:00,07-06-2023,A2,02:48:00,03:00:00,07-06-2023,A3,04:33:00,05:30:00,07-06-2023,A4,03:21:00,04:18:00,07-06-2023,A5,03:39:00,05:48:00,07-06-2023,A6,01:24:00,01:33:00,07-06-2023,A7,07:06:00,09:09:00
07-06-2023,A1,01:33:00,01:45:00,07-06-2023,A2,03:03:00,03:15:00,07-06-2023,A3,05:33:00,06:15:00,07-06-2023,A4,04:21:00,04:33:00,07-06-2023,A5,05:51:00,06:03:00,07-06-2023,A6,01:36:00,02:48:00,07-06-2023,A7,09:12:00,10:00:00
07-06-2023,A1,01:48:00,03:30:00,07-06-2023,A2,03:18:00,03:48:00,07-06-2023,A3,06:18:00,07:18:00,07-06-2023,A4,04:36:00,04:45:00,07-06-2023,A5,06:06:00,06:48:00,07-06-2023,A6,02:51:00,03:03:00,07-06-2023,A7,10:03:00,12:30:00
07-06-2023,A1,03:33:00,03:45:00,07-06-2023,A2,03:51:00,04:00:00,07-06-2023,A3,07:21:00,08:45:00,07-06-2023,A4,04:48:00,05:33:00,07-06-2023,A5,06:51:00,07:00:00,07-06-2023,A6,03:06:00,03:21:00,07-06-2023,A7,12:33:00,12:48:00
07-06-2023,A1,03:48:00,04:00:00,07-06-2023,A2,04:03:00,04:15:00,07-06-2023,A3,08:48:00,09:03:00,07-06-2023,A4,05:36:00,05:45:00,07-06-2023,A5,07:03:00,07:30:00,07-06-2023,A6,03:24:00,05:00:00,07-06-2023,A7,12:51:00,14:00:00
07-06-2023,A1,08:00:00,09:00:00,07-06-2023,A2,04:18:00,05:15:00,07-06-2023,A3,09:06:00,11:45:00,07-06-2023,A4,05:48:00,06:18:00,07-06-2023,A5,07:33:00,08:51:00,07-06-2023,A6,05:03:00,07:21:00,07-06-2023,A7,14:03:00,14:48:00
07-06-2023,A1,09:03:00,10:15:00,07-06-2023,A2,05:18:00,06:00:00,07-06-2023,A3,11:48:00,12:00:00,07-06-2023,A4,06:21:00,06:45:00,07-06-2023,A5,08:54:00,09:06:00,07-06-2023,A6,07:24:00,07:33:00,07-06-2023,A7,14:51:00,16:18:00
07-06-2023,A1,10:18:00,10:45:00,07-06-2023,A2,06:03:00,06:30:00,07-06-2023,A3,16:00:00,16:15:00,07-06-2023,A4,06:48:00,08:48:00,07-06-2023,A5,09:09:00,09:30:00,07-06-2023,A6,07:36:00,08:30:00,07-06-2023,A7,16:21:00,17:03:00
07-06-2023,A1,10:48:00,11:15:00,07-06-2023,A2,06:33:00,07:15:00,07-06-2023,A3,16:18:00,16:30:00,07-06-2023,A4,08:51:00,10:18:00,07-06-2023,A5,09:33:00,11:33:00,07-06-2023,A6,08:33:00,10:21:00,07-06-2023,A7,17:06:00,19:15:00
07-06-2023,A1,11:18:00,11:30:00,07-06-2023,A2,07:18:00,08:00:00,07-06-2023,A3,16:33:00,17:45:00,07-06-2023,A4,10:21:00,10:30:00,07-06-2023,A5,11:36:00,12:03:00,07-06-2023,A6,10:24:00,13:21:00,07-06-2023,A7,19:18:00,19:33:00
07-06-2023,A1,11:33:00,14:15:00,07-06-2023,A2,12:00:00,13:00:00,07-06-2023,A3,17:48:00,18:45:00,07-06-2023,A4,10:33:00,11:18:00,07-06-2023,A5,12:06:00,12:15:00,07-06-2023,A6,13:24:00,14:39:00,07-06-2023,A7,19:36:00,21:48:00
07-06-2023,A1,14:18:00,14:30:00,07-06-2023,A2,13:03:00,13:30:00,07-06-2023,A3,18:48:00,19:00:00,07-06-2023,A4,11:21:00,11:48:00,07-06-2023,A5,12:18:00,12:45:00,07-06-2023,A6,14:42:00,14:45:00,07-06-2023,A7,21:51:00,22:03:00
07-06-2023,A1,14:33:00,15:15:00,07-06-2023,A2,13:33:00,13:45:00,07-06-2023,A3,19:03:00,22:15:00,07-06-2023,A4,11:51:00,12:00:00,07-06-2023,A5,12:48:00,13:18:00,07-06-2023,A6,14:48:00,16:00:00,07-06-2023,A7,22:06:00,22:33:00
07-06-2023,A1,15:18:00,16:45:00,07-06-2023,A2,13:48:00,16:48:00,07-06-2023,A3,22:30:00,01:00:00,07-06-2023,A4,12:03:00,13:15:00,07-06-2023,A5,13:21:00,13:36:00,07-06-2023,A6,16:03:00,17:00:00,07-06-2023,A7,22:36:00,23:03:00
07-06-2023,A1,16:48:00,17:30:00,07-06-2023,A2,16:51:00,19:45:00,,,,,07-06-2023,A4,13:18:00,13:33:00,07-06-2023,A5,13:39:00,14:36:00,07-06-2023,A6,17:03:00,17:15:00,07-06-2023,A7,23:06:00,23:15:00
07-06-2023,A1,17:33:00,18:30:00,07-06-2023,A2,19:48:00,20:00:00,,,,,07-06-2023,A4,13:36:00,14:33:00,07-06-2023,A5,14:39:00,16:51:00,07-06-2023,A6,17:18:00,21:33:00,07-06-2023,A7,23:18:00,01:57:00
07-06-2023,A1,18:33:00,20:30:00,07-06-2023,A2,20:03:00,20:15:00,,,,,07-06-2023,A4,14:36:00,15:00:00,07-06-2023,A5,16:54:00,17:33:00,07-06-2023,A6,21:36:00,23:33:00,,,,
07-06-2023,A1,20:33:00,21:30:00,07-06-2023,A2,20:18:00,20:33:00,,,,,07-06-2023,A4,15:03:00,16:00:00,07-06-2023,A5,17:36:00,19:30:00,07-06-2023,A6,23:36:00,00:00:00,,,,
07-06-2023,A1,21:33:00,21:45:00,07-06-2023,A2,20:36:00,20:45:00,,,,,07-06-2023,A4,20:00:00,20:48:00,07-06-2023,A5,19:33:00,19:48:00,,,,,,,,
07-06-2023,A1,21:48:00,22:15:00,07-06-2023,A2,20:48:00,21:15:00,,,,,07-06-2023,A4,20:51:00,22:00:00,07-06-2023,A5,19:51:00,20:00:00,,,,,,,,
07-06-2023,A1,22:18:00,22:30:00,07-06-2023,A2,21:18:00,22:18:00,,,,,07-06-2023,A4,22:03:00,00:48:00,,,,,,,,,,,,
07-06-2023,A1,22:33:00,23:45:00,07-06-2023,A2,22:21:00,22:45:00,,,,,,,,,,,,,,,,,,,,
07-06-2023,A1,23:48:00,00:15:00,07-06-2023,A2,22:48:00,23:00:00,,,,,,,,,,,,,,,,,,,,
,,,,07-06-2023,A2,23:03:00,23:30:00,,,,,,,,,,,,,,,,,,,,
,,,,07-06-2023,A2,23:33:00,23:48:00,,,,,,,,,,,,,,,,,,,,
,,,,07-06-2023,A2,23:51:00,01:48:00,,,,,,,,,,,,,,,,,,,,


Подробнее здесь: https://stackoverflow.com/questions/764 ... me-columns
Реклама
Ответить Пред. темаСлед. тема

Быстрый ответ

Изменение регистра текста: 
Смайлики
:) :( :oops: :roll: :wink: :muza: :clever: :sorry: :angel: :read: *x)
Ещё смайлики…
   
К этому ответу прикреплено по крайней мере одно вложение.

Если вы не хотите добавлять вложения, оставьте поля пустыми.

Максимально разрешённый размер вложения: 15 МБ.

  • Похожие темы
    Ответы
    Просмотры
    Последнее сообщение

Вернуться в «Python»