from IPython.core.display import HTML
HTML(open("styles/custom.css", "r").read())

print "Hello World"

%%script glpsol -m /dev/stdin -o /dev/stdout --out output

printf "Hello, World\n";
end;

print output

%%script glpsol -m /dev/stdin

param a := 12.3;
param b := 13;

display a + b;

end;

%%script --out output glpsol -m /dev/stdin -y out.txt 

param a := 12.3;
param b := 13;

display a + b;

end;

f = open('out.txt')
print f.read()
f.close()

print output

%%script --out output glpsol -m /dev/stdin

# declare problem variables
var x;
var y;
var z;

# list all equations
eqn1 : 3*x + 2*y + z = 12;
eqn2 : 2.1*x + y = -3;
eqn3 : y - z = 4;

# solve
solve;

# display results
display x, y, z;

end;

print output

f = open('out.txt');
print(f.read())
f.close()

%%writefile input.csv
Name, Age
Abigail, 22.1
Brent, 24.1
Carla, 21.0
Doug, 20.0

%%script --out output glpsol -m /dev/stdin

set NAMES;

param Age{NAMES};

table tin IN "CSV" "input.csv" : NAMES <- [Name], Age;
    
for {n in NAMES}: printf "%s\n", n;
    
end;

print output

import pandas
pandas.read_csv("input.csv")

%%script --out output glpsol -m /dev/stdin

# declare problem variables
var x;
var y;
var z;

# list all equations
eqn1 : 3*x + 2*y + z = 12;
eqn2 : 2.1*x + y = -3;
eqn3 : y - z = 4;

# solve
solve;

# output results to .csv file
table result {1..1} OUT "CSV" "out.csv" : x, y, z;
    
end;

print output

f = open('out.csv');
print(f.read())
f.close()

import pandas
df = pandas.read_csv("out.csv");
display(df)
df.plot(kind='bar')

%%writefile input.csv
A,B,C
12.2, 13.1, 13.2

%%script --out output glpsol -m /dev/stdin

set S;

param a;
param b;
param c;

table input IN "CSV" "input.csv": S <- [A], a~A, b~B, c~C;
    
end;

print output