๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

Python

 (75)
[Python] Django https://wikidocs.net/71259 3-05 ๋กœ๊ทธ์ธ๊ณผ ๋กœ๊ทธ์•„์›ƒ `[์™„์„ฑ ์†Œ์Šค]` : [github.com/pahkey/jump2django/tree/3-05](https://github.com/pahkey/jump2django/tree ... wikidocs.net
[Python] Streamlit A faster way to build and share data apps Streamlit turns data scripts into shareable web apps in minutes. All in pure Python. No frontโ€‘end experience required. https://streamlit.io/ Streamlit • The fastest way to build and share data apps Streamlit is an open-source app framework for Machine Learning and Data Science teams. Create beautiful web apps in minutes. streamlit.io Gallery https://stre..
[Python] Excel, Word ๋‹ค๋ฃจ๊ธฐ Excel openpyxl from openpyxl import Workbook from openpyxl import load_workbook from openpyxl.styles import PatternFill class Copy_excel: def __init__(self, src): self.wb = load_workbook(src) def select_sheet(self, sheet_nm): self.ws = self.wb[sheet_nm] # Write the value in the cell defined by row_dest+column_dest def write_workbook(self, row_dest, column_dest, value): c = self.ws.cell(row = row..
[Python] XlsxWriter - Excel ๋‹ค๋ฃจ๊ธฐ Pandas - Dataframe๊ณผ ํ•จ๊ป˜ ์‚ฌ์šฉํ•˜๊ธฐ writer = pd.ExcelWriter(out_file, engine='xlsxwriter') df.to_excel(writer, sheet_name='Sheet1', freeze_panes = (1, 0), index=False) workbook = writer.book worksheet = writer.sheets['Sheet1'] worksheet.set_zoom(80) # zoom ์„ค์ • # row, col, width, format worksheet.set_column(0, 0, 10, workbook.add_format({'num_format': '#,##0', 'border': 1, 'align': 'center', 'text_wrap': ..
[Python] Pandas - Dataframe ํ•จ์ˆ˜ ๋ชจ์Œ merge result_df = pd.merge(df1, df2, how='left', on='key') result_df = pd.merge(df1, df2, how='left', left_on='name1', right_on='name2') drop column df.drop(columns=['datetime'], inplace=True) reset index df.reset_index(inplace=True, drop=True) new col with apply df['new_col'] = df.apply(lambda x: json.loads(x['loc'])['c'][1], axis=1) sort # ์—ด ์ด๋ฆ„ ์ˆœ์„œ axis=1 # ๋‚ด๋ฆผ์ฐจ์ˆœ ascending=False df.sort_values(b..
[Python] sqlalchemy, json์œผ๋กœ ๋ณ€๊ฒฝ ํ›„ ๋ฆฌํ„ด user = User.query df = pd.read_sql(user.statement, user.session.bind) #df = df.drop(columns=['updated_datetime']) df.columns = map(str.lower, df.columns) result_json = json.loads(df.astype(str).to_json(orient='records', double_precision=15, date_format='iso')) result_json = json.dumps(result_json).replace('None', '') result_json = json.loads(result_json)
[Flask] ํŒŒ์ผ ์—…๋กœ๋“œ
[Python] Flask - Failed to load module script: The server responded with a non-JavaScript MIME type of "text/plain". Strict MIME type checking is enforced for module scripts per HTML spec. ์“ฐ๋Š”๋ฐ ์˜ค๋ฅ˜ ๋ฐœ์ƒ ใ… ใ…  Failed to load module script: The server responded with a non-JavaScript MIME type of "text/plain". Strict MIME type checking is enforced for module scripts per HTML spec. import mimetypes mimetypes.add_type('application/javascript', '.mjs') stackoverflow.com/questions/56587108/flask-how-to-use-es6-modules/62236927#62236927 Flask: How to use ES6 modules? I have a working Flask app t..

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”