๐ ๊ณต๋ถํ๋ ์ง์ง์ํ์นด๋ ์ฒ์์ด์ง?
HTML์์ Python์ ์ฌ์ฉํ ์ ์๋ PyScript (3) ๋ณธ๋ฌธ
๐ฉ๐ป ๋ฐฑ์๋(Back-End)/Node js
HTML์์ Python์ ์ฌ์ฉํ ์ ์๋ PyScript (3)
์ง์ง์ํ์นด 2022. 11. 25. 11:11728x90
๋ฐ์ํ
<๋ณธ ๋ธ๋ก๊ทธ๋ itadventrue ๋์ ๋ธ๋ก๊ทธ๋ฅผ ์ฐธ๊ณ ํด์ ๊ณต๋ถํ๋ฉฐ ์์ฑํ์์ต๋๋ค :-)>
https://itadventure.tistory.com/544
๐ Pandas ๋ฅผ ์ฌ์ฉํด์ csv ํ์ผ ๋ถ๋ฌ์ค๊ธฐ
โ ๋ชจ๋ ์ ์ธ
<py-env> ํ๊ทธ ์์ pandas ์ฌ์ฉ ์ ์ธ
<html>
<head>
<link rel="stylesheet" href="https://pyscript.net/alpha/pyscript.css" />
<script defer src="https://pyscript.net/alpha/pyscript.js"></script>
<py-env>
- pandas
</py-env>
</head>
<body>
:
์ธํฐ๋ท URL์ ๋ถ๋ฌ์ค๊ธฐ ์ํ open_url ํจ์๋ฅผ ๋ถ๋ฌ์ค๊ธฐ
import pandas as pd
from pyodide.http import open_url
โ ์ฃผ์
csv.write(df.head()) => csv.write(df) ๋ก ๊ต์
<div id="csv"></div>
<py-script>
import pandas as pd
from pyodide.http import open_url
df = pd.read_csv(open_url("http://dreamplan7.cafe24.com/pyscript/py4.csv"))
csv = Element('csv')
csv.write(df)
</py-script>
Element ํจ์๋ฅผ ์ด์ฉํ์ฌ ์ถ๋ ฅํ HTML ์์๋ฅผ ์ ํ
df = pd.read_csv(open_url("http://dreamplan7.cafe24.com/pyscript/py4.csv"))
csv = Element('csv')
id๊ฐ์ "~~~~~~" ๋ก ์ง์ด์ค DIV ํ๊ทธ ๋จผ์ ์ ์ธ
<div id="csv"></div>
Element๋ก ๋ฐ์์จ HTML ๊ฐ์ฒด์ ๊ฒฐ๊ณผ๋ฅผ ์ถ๋ ฅํจ
ํ์ฌ ํ์ด ์คํฌ๋ฆฝํธ๊ฐ ์์นํ ๊ณณ์ด ์๋๋ผ, ID ๊ฐ์ด "csv" ํ๊ทธ์ธ ๊ณณ์ ๊ฒฐ๊ณผ๊ฐ ์ถ๋ ฅ
csv = Element('csv')
csv.write(df)
</py-script>
โ ๊ทธ๋ํ ์ฝ๋
<html>
<head>
<title>
Read CSV with Pandas using PyScript
</title>
<link rel="stylesheet" href="https://pyscript.net/alpha/pyscript.css" />
<script defer src="https://pyscript.net/alpha/pyscript.js"></script>
<py-env>
- pandas
</py-env>
</head>
<body>
<style type="text/css">
table.dataframe th {
border: 1px black solid;
background-color:black;
color: white !important;
padding: 2px 5px;
}
table.dataframe td {
border: 1px black solid !important;
color: black !important;
padding: 2px 5px;
}
</style>
<h1>ํ์ด์คํฌ๋ฆฝํธ์์ ํ๋ค์ค(Pandas)๋ก CSV ์ฝ๊ธฐ</h1>
<div id="csv"></div>
<py-script>
import pandas as pd
from pyodide.http import open_url
# URL ์์ csv ๋ฐ์ดํฐ๋ฅผ ์ฝ์ด ํ๋ค์ค ๋ฐฐ์ด๋ก ๋ณํํฉ๋๋ค.
df = pd.read_csv(open_url("http://dreamplan7.cafe24.com/pyscript/py4.csv"))
# ์ถ๋ ฅํ HTML ์์๋ฅผ ์ ํ
csv = Element('csv')
# ํด๋น HTML ์์์ ๊ฒฐ๊ณผ๋ฅผ ์ถ๋ ฅํฉ๋๋ค.
csv.write(df)
</py-script>
</body>
</html>
โ ์์ ๋ฒ์
<html>
<head>
<title>
Read CSV with Pandas using PyScript
</title>
<link rel="stylesheet" href="https://pyscript.net/alpha/pyscript.css" />
<script defer src="https://pyscript.net/alpha/pyscript.js"></script>
<style type="text/css">
table.dataframe th {
background-color: #EA6153 !important;
color: white !important;
text-align:center !important;
padding: 5px 15px;
font-size:9pt !important;
}
table.dataframe td {
color: black !important;
text-align:center !important;
padding: 5px 15px;
font-size:9pt !important;
}
table.dataframe tr {
background-color: #FFFFFF !important;
}
table.dataframe tr:nth-child(odd) {
background-color: #E9E9E9 !important;
}
</style>
<py-env>
- pandas
</py-env>
</head>
<body style="padding:20px;">
<h2>ํ์ด์คํฌ๋ฆฝํธ์์ ํ๋ค์ค(Pandas)๋ก CSV ์ฝ๊ธฐ</h1>
<div id="csv" style="margin-top:10px"></div>
<py-script>
import pandas as pd
from pyodide.http import open_url
# URL ์์ csv ๋ฐ์ดํฐ๋ฅผ ์ฝ์ด ํ๋ค์ค ๋ฐฐ์ด๋ก ๋ณํํฉ๋๋ค.
df = pd.read_csv(open_url("http://dreamplan7.cafe24.com/pyscript/py4.csv"))
# ์ถ๋ ฅํ HTML ์์๋ฅผ ์ ํ
csv = Element('csv')
# ํด๋น HTML ์์์ ๊ฒฐ๊ณผ๋ฅผ ์ถ๋ ฅํฉ๋๋ค.
csv.write(df)
</py-script>
</body>
</html>
728x90
๋ฐ์ํ
'๐ฉโ๐ป ๋ฐฑ์๋(Back-End) > Node js' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
HTML์์ Python์ ์ฌ์ฉํ ์ ์๋ PyScript (5) (0) | 2022.11.25 |
---|---|
HTML์์ Python์ ์ฌ์ฉํ ์ ์๋ PyScript (4) (1) | 2022.11.25 |
HTML์์ Python์ ์ฌ์ฉํ ์ ์๋ PyScript (2) (0) | 2022.11.25 |
HTML์์ Python์ ์ฌ์ฉํ ์ ์๋ PyScript (1) (0) | 2022.11.25 |
์น์์ ๊ทธ๋ํ ๋ง๋๋ Plot.js ์์๋ณด๊ธฐ (0) | 2022.11.22 |
Comments