samirsaci

def create_json(df_nodes, df_links):
    ''' Create json from dataframes'''
    json1 = []
    for index, row in df_nodes.reset_index().iterrows():
        dico = {}
        dico['group'] = int(row['group'])
        dico['name'] = row['name']
        json1.append(dico)

    json2 = []

samirsaci

{
  "links": [
    {
      "source": 0, 
      "target": 0, 
      "value": 1947
    }, 
    {
      "source": 0, 
      "target": 1, 

samirsaci

d3.json("/get-json").then(function(brands) {
  var matrix = [],
      nodes = brands.nodes,
      n = nodes.length;

samirsaci

Sub SaveMSG_as_HTML()
Application.ScreenUpdating = False
'Initiliaze Parameters
Dim olMsg As MailItem
Dim strPath As String
Dim strMsg As String
Dim strHTML As String
Dim Sender, Received_Time As String
Dim ID As Integer
ID = 1

samirsaci

'Loop through each (.msg) file in your folder strIn
Do While myFile <> ""
    
    'Create record in Excel File
    On Error Resume Next
    Sheets(1).Cells(ID + 1, 1) = ID     
    Sheets(1).Cells(ID + 1, 7) = myFile
    'Open (.msg) file 
    Set olMsg = Session.OpenSharedItem(strIn & myFile)
    strName = ID & ".html"

samirsaci

Sub SaveMSG_as_HTML()
Application.ScreenUpdating = False

Dim olMsg As MailItem
Dim strPath As String
Dim strMsg As String
Dim strHTML As String


Dim Sender, Received_Time As String

samirsaci

samirsaci

import pandas as pd
import matplotlib.pyplot as plt

# Import
df = pd.read_excel('In/' + '1-2017.xlsx')
print("{:,} order lines for {:,} orders".format(len(df), df.ORDER_NUMBER.nunique()))

samirsaci

# BOX/SKU
df_par = pd.DataFrame(df.groupby(['SKU'])['BOX'].sum())
df_par.columns = ['BOX']

# Sort Values
df_par.sort_values(['BOX'], ascending = False, inplace = True)
df_par.reset_index(inplace = True)

# Cumulative Sum 
df_par['CumSum'] = df_par['BOX'].cumsum()

samirsaci