New_column = pd.Series(option1, name='Debit')īased on the user input from the select box for the index row and column (Description column, index=1), I want to add the user input into a new column called "Debit" with the input at the index. ('Cash', 'Accounts Receivable', 'Land', 'Equipment', 'Salaries Expense', 'Rent Expense', 'Depreciation Expense', 'Insurance Expense'))) # Assign "Other" for Transactions with no typeĭf = df.fillna('Other') # Assign a Transaction Type for each Transactionĭf.('WITHDRWL|Withdrawal|withdrawal|WITHDRAWAL'), 'Transaction Type'] = 'Withdrawal'ĭf.('Bill Payment|bill payment|Bill payment|bill Payment|BILL PAYMENT|scheduled payment'), 'Transaction Type'] = 'Bill Payment'ĭf.('Check|CHECK|check'), 'Transaction Type'] = 'Check'ĭf.('DEPOSIT|deposit|Deposit|DES') & (df > 0), 'Transaction Type'] = 'Deposit'ĭf.('DES') & (df < 0), 'Transaction Type'] = 'ACH'ĭf.('transfer|TRANSFER|Transfer'), 'Transaction Type'] = 'Transfer'ĭf.('Purchase|PURCHASE|purchase'), 'Transaction Type'] = 'Debit Card Purchase'ĭf.('CHECK ORDER|OVERDRAFT'), 'Transaction Type'] = 'Bank Charge' Pattern = '|'.join()ĭf = df.str.replace(pattern, '') # Assign each transaction as either a debit or creditĭf = ] # Can be used wherever a "file-like" object is accepted:ĭf = pd.read_csv(uploaded_file, on_bad_lines='skip')
Uploaded_file = st.file_uploader("Choose a file") Looking at the file it is trying to lock, nothing jumps out at me on why it can not lock it: -rwxr-xr-x 1 mysql mysql 3276800 Jul 29 06:20 '#ib_redo0'* I have looked at other posts and have verified/tried: A) There is not another mysql instance running B) AppArmor has been edited to allow access (nothing has changed & re-verified) The server crashed and generated a crash log - now I get this error when trying to restart the server. This instance of mysql has been running fine for over a year on ubuntu. T10:46:36.124674Z 0 Data Dictionary initialization failed.
T10:46:36.124480Z 1 Failed to initialize DD Storage Engine T10:46:35.911872Z 1 Plugin initialization aborted with error Cannot open a file. T10:46:33.680919Z 1 InnoDB initialization has started.