Tuesday, March 24, 2020

flask

from flask import Flask, render_template
import pandas as pd

app = Flask(__name__)

@app.route('/')
def home_page():
    return render_template("home.html")

@app.route('/')
def another_page():
    table = pd.DataFrame.from_csv("gender_submission.csv")
    return render_template("dataset.html", data=table.to_html())

if __name__ == '__main__':
    app.run(debug=True, use_reloader=True,host = '192.168.1.7')

Sunday, March 8, 2020

pyhton

import numpy as np
import pandas as pd
import pyarrow as pa
#df = pd.DataFrame({'one': [20, np.nan, 2.5],'two': ['january', 'february', 'march'],'three': [True, False, True]},index=list('abc'))#table = pa.Table.from_pandas(df)
import pyarrow.parquet as pq
d = pd.read_csv('C:\\Users\\senthil\\PycharmProjects\\s3aws\\app.csv')
t = pa.Table.from_pandas(d)
print(t)
pq.write_table(t, 'C:\\Users\\senthil\\PycharmProjects\\s3aws\\app.parquet')

#pdf = pq.read_pandas('C:\\Users\\senthil\\PycharmProjects\\s3aws\\gender_submission.parquet').to_pandas()pdf=pd.read_parquet('C:\\Users\\senthil\\PycharmProjects\\s3aws\\userdata1.parquet', engine='pyarrow').to_csv()
print(pdf)

#table2 = pq.read_table('C:\\Users\\senthil\\PycharmProjects\\s3aws\\gen4der_submission.parquet')#print(table2)