Тренинг Платформа Engee (LTC/MBD)

using XLSX

xf = XLSX.readxlsx( "data/EPLresults.xlsx" )

using DataFrames, XLSX

df = DataFrame( XLSX.readtable("data/EPLresults.xlsx", "Sheet1") )

m = XLSX.readdata("data/EPLresults.xlsx", "Sheet1!B2:K21")

x = rand( 5, 3 )
y = DataFrame( x, ["A", "B", "C"] )

z = DataFrame( x, :auto )

names(df)

propertynames(df)

df[:,:]

df[1:3, :]

v = ["Home Wins", "Home GF"]

top5 = df[1:5, v]

select(df[1:3, :], Not("Home Wins"))

df[1, :]

df[ 1, 2 ] = df[ 1, 2 ] + 1

df[1, :]

z

rename!(z, ["X", "Y", "Z"])

rename!( df, replace.(names(df), " " => "") )

names(df)

using DataFrames, XLSX

df = DataFrame( XLSX.readtable("data/EPLresults.xlsx", "Sheet1") )

[ DataFrame( ["SampleTeam" 1 2 3 4 5 6 7 8 9 10], names(df)) ; df ]

df[:, "Team"]

df.Team

df."Home Wins"

df.Position = 1:size(df,1)

df[ :, 7:end ]

df.Points = 3 * (df."Home Wins" + df."Away Wins")

using CSV

CSV.write( "data/csv_output.csv", df )

#using DataFrames
data = CSV.read( "data/csv_output.csv", DataFrame )