ออนไลน์ล่างกรณีแปลง

I am trying to create a gui helps me to update existing xlsm file easier in a simple gui.

So I need now to create a UI Element Searchbox with filters some thing like this

so how to update this xlsm file by create a gui like this with a simple list view contains check boxes contains master primary key values in column in existing xlsm file, as I think pandas and openpyxl could help me to create an array and put this column values in this check box list, and this is the excel file I want to updatem and this column I marked I want want to put this values in this list check box

.

So If there's any way to create some thing like this or tutorial for this?

I Tried to create something like this but without check boxe.

and this is my code

from tkinter import *import pandas as pdimport os# First create application classclass Application(Frame):    def __init__(self, master=None):        Frame.__init__(self, master)        self.pack()        self.create_widgets()    # Create main GUI window    def create_widgets(self):        self.search_var = StringVar()        self.search_var.trace("w", lambda name, index, mode: self.update_list())        self.entry = Entry(self, textvariable=self.search_var, width=13)        self.lbox = Listbox(self, width=45, height=15)        self.entry.grid(row=0, column=0, padx=10, pady=3)        self.lbox.grid(row=1, column=0, padx=10, pady=3)        # Function for updating the list/doing the search.        # It needs to be called here to populate the listbox.        self.update_list()    def update_list(self):        search_term = self.search_var.get()        # Just a generic list to populate the listbox        mydir = (os.getcwd()).replace('\\', '/') + '/'        mySiteCode = pd.read_excel(r'' + mydir + 'Governance_Tracker - Copy - Copy.xlsm', usecols=['SiteCode'],                                        encoding='latin-1', header=1)        a = mySiteCode['SiteCode'].values.tolist()        self.lbox.delete(0, END)        for item in a:            if search_term.lower() in item.lower():                self.lbox.insert(END, item)root = Tk()root.title('Filter Listbox Test')app = Application(master=root)print'Starting mainloop()'app.mainloop()

I'm using notepad++ and I'm finding that when I use regex to search for strings where I specifically want to find lowercase letters ("[a-z]") it will sometimes return uppercase letters.

I originally was searching using the string:

^[A-Z][a-z].+?$

With the purpose of deleting any line in my file that began with an uppercase character, followed by a lowercase, followed by anything until the end of the line. However, this returned lines like, "CLONE" and "DISEASE" which were only capital letters. Out of curiosity, I tried:

^[a-z].+?$

And it still returned those lines in all-caps. Finally, I tried:

^[\u0061-\u007A].+?$

And it still returned lines of all-caps text. Is there something outside of my brackets that's causing this to happen?

I have a large number of data frame objects, and I want to apply a function that only converts the character strings to lowercase and leaves the classes of every thing else alone.

I have tried mutate_all(df,tolower) but that affected all variables/columns

I have tried mutate_at(names(select_if(df,is.character)),tolower) and this does work on an individual dataframe. But I need to do this across many data frames all at the same time. I am really bad at Iteration and loops, so if code that iterates this line of code over every object may be a solution.

Or, because I also have these dataframes in a list, I have tried

modify_depth(df,.depth = 2, mutate_at(names(select_if(,is.character)),tolower))But that did not work. modify is in the purrr package

library(dplyr)library(purrr)data_frame_Rate_Table <- data.frame(Policy_Class = c("rED", "WhIte","BlUe"),                                   Rate=c(3,9,19),"Factor_1"= 1:3, Factor_2=7:9, stringsAsFactors = FALSE)data_frame_Policyholders <- data.frame(Policy_number  = 1:10,                                       Policy_Class=rep(c("REd","red","wHite","BLue","bluE"),2),                                       Risk=c(rep("HiGh",5),rep("LOW",5)),                                        Lapse=rep(c("Y","N"),5), stringsAsFactors = FALSE)data_frame_list <- list(data_frame_Policyholders, data_frame_Rate_Table)

I would just like all character strings to be lowercase without affecting the other classes.

Reading the PostgreSQL docs, I see both upper and lower case used for SQL keywords, types and functions, for example. I'm wondering if there is a common practice that most folks follow.

Basically, I want to find a convention to follow and stick to it. e.g. the ANSI SQL Docs seem to always use uppercase for keywords like SELECT, AS, types like NUMERIC and function calls like CAST().

Is there a recommended or at least prevailing convention?

I've just compiled the version MySQL 8.0.12 in a Ubuntu 16.0.4.

After following the instructions in the website and making the following my.cnf file:

[mysqld]datadir=/usr/local/mysql/datasocket=/tmp/mysql.sockport=3306log-error=/usr/local/mysql/data/localhost.localdomain.erruser=mysqlsecure_file_priv=/usr/local/mysql/mysql-fileslocal_infile=OFFlog_error = /var/log/mysql/error.log# Remove case sensitive in table nameslower_case_table_names=1

I get the following error:

2018-08-11T19:45:06.461585Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0').

What should I change so that data dictionary is aligned to server settings?