# -*- coding: utf-8 -*-
"""
Created on Fri Jun  4 10:06:34 2021

@author: Sim
"""
############## latex table
import pandas as pd
import numpy as np

df = pd.read_csv(r'D:\HTEX\Pythonbk\codesdata\bmi.csv')

ftab2 = df['height'].value_counts(bins=[-np.Inf, 150, 155, 160, 165, 170, 175, np.Inf], 
                                  sort=False)
x = np.linspace(147.5, 177.5, 7)
ldf = pd.DataFrame({'빈도($w_i$)': ftab2, 
                      '대푯값($x_i$)': x, '$x_iw_i$': ftab2 * x })
sums = ldf.apply(np.sum, axis=0)
sums.name = '합'
ldf = ldf.append(sums)
latexdf=ldf.to_latex()
print(latexdf)