Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from __future__ import print_function
- import os
- import os.path
- import pandas as pd
- from templates.auc_scan_data import DATABASE
- def main_data_from_lua():
- wow_auction_db = f'C:\Games\Sirus\WTF\Account\ACCOUNTNAME\SavedVariables\Auctionator.lua'
- file_auc_db = os.path.abspath(wow_auction_db )
- with open(file_auc_db, 'r', encoding='utf-8') as f:
- bd_line = ''
- for line in f:
- bd_line += line
- # Убираем мусор и создаем готовый к записи файл
- AUC_price_db = bd_line.split('AUCTIONATOR_PRICE_')[1].split('AUCTIONATOR_LAST_SCAN_TIME')[0]
- AUC_price_db = AUC_price_db.replace('=', ':').replace('[', '').replace(']','')
- name_var, data_var = AUC_price_db[:8], AUC_price_db[10:]
- AUC_price_db = name_var + "=" + data_var
- with open( 'templates/auc_scan_data.py', 'w', encoding='utf-8' ) as f:
- f.write(AUC_price_db)
- main_data = DATABASE["Algalon x4 - 3.3.5a_Horde"]
- for item in main_data.keys():
- if type(main_data[item]) == dict:
- main_data[item] = main_data[item]['mr']
- main_data[item] = main_data[item]/10000
- df_main_data = pd.DataFrame.from_dict ( main_data, orient='index' )
- df_main_data.to_excel ( 'auc_data.xlsx', sheet_name='aux' )
Add Comment
Please, Sign In to add comment