ITips(US)

How to insert bulk data into MySQL with Python

When we try to insert huge data to MySQL table with using Python code, sometimes it takes long time. If possible, we want to insert bulk data in short time. So today I will introduce about "How to insert bulk data into MySQL with Python". How to insert bulk data into MySQL with Python In order to insert bulk data into MySQL with Python, we can use pymysql module. And we can use  executemany method instead of execute method. pymysql bulk insert So check it with test code. Test with pymysql So let's try with pymysql module. According to this test, we can understand that executemany is faster than execute . […]

2024/02/29 23:28

The reason of "Your administrator disabled reporting or changed the relationship for a custom object" in Salesforce

Salesforce has a function to create "report". Although it is inferior in terms of functionality compared to various BI tools, it is convenient to be able to create tables and graphs using its internal functions. You can also create a dashboard by combining multiple reports. However, the following error may be displayed on the dashboard or report: This report cannot be edited or run. An administrator has disabled reporting for a custom object or modified a relationship. I understand that the report cannot be run, but even after looking at the message, I have no idea what to fix. What should I do if this error message appears ?So today, I will explain about "The reason of "Your administrator disabled reporting or changed the relationship for a custom object" in Salesforce".

2024/02/26 21:11

Pandas error "Unalignable boolean Series provided as indexer"

pandas.DataFrame is useful to handle table format data. With using pandas, we can import CSV or Excel data and extract specific rows. One day, pandas said such an error. IndexingError: Unalignable boolean Series provided as indexer (index of the boolean Series and of the indexed object do not match). This error message was difficult for us to understand. What was the cause of error ?So today I will introduce about "Pandas error 'Unalignable boolean Series provided as indexer'".

2024/02/25 17:55

The reason of "RuntimeError: cryptography is required"

One day, when I tried to connect to MySQL from Python, I got this error. RuntimeError: cryptography is required What is this error ?So today, I will introduce about 'The reason of "RuntimeError: cryptography is required"'.

2024/02/25 17:05

How to calculate cosine similarity of array in BigQuery

BigQuery(BQ) is very useful for data analysis or processing. It is good for handling huge data. It returns summary result in short time. BQ has one useful data format "array". When we consider array as vector, we may want cosine similarity of vectors. So how can we get cosine similarity ? So today I introduce about "How to calculate cosine similarity of array in BigQuery".

2024/02/25 15:52

How to decompose "from-to term" record by each date record in BigQuery

BQ can handle date data. Then sometimes we handle "from-to" record like below. date_from date_to 2021-11-01 2021-11-05 Once we get this record, we would like to convert it to each date records like below. So how can we decompose "from-to term" record by each date record ?So today I introduce about "How to decompose "from-to term" record by each date record in BigQuery".

2024/02/25 14:26

How to get YYYYMM format string from date column in BigQuery

BigQuery(BQ) is very useful for data analysis or processing. BQ has date type. So you may want to extract YYYYMM year-month data from date column. But how can we get YYYYMM format data ? So today I will introduce about "How to get YYYYMM format from date column in BigQuery".

2024/02/24 23:18

The reason why comparison and conditional aggregation fail in BigQuery

When we handle big data, sometimes we want to extract or summarize data that meets specific conditions. Usually we use comparison operator like below. WHERE COLUMN1 = "A" SUM(IF(COLUMN1 = "A",1,0) But it fails in specific case. Why did it fail ?So today I introduce about "Why comparison and conditional aggregation fails in BigQuery".

2024/02/24 22:43

How to rank data considering duplication in BigQuery

When we handle data, sometimes we would like to do numbering. For example, extract from first to third record in each category .In order to get ranking in whole data, we should use order by clause. But how can we get ranking number ?And also if 4 records have same score, it is difficult to choose 3 records. How can we number records without duplication ?So today I will introduce about "How to rank data considering duplication in BigQuery".

2024/02/24 13:34

Dynamic unpivot SQL for multiple columns in Bigquery

During data handling, sometimes we would like to change columns to rows. But in order to use UNPIVOT, we have to write each column name in unpivot clause. It is bothering. It is better to set columns dynamically. Are there any easier way for unpivoting ? So today I introduce about "Dynamic unpivot SQL for multiple columns in BigQuery".

2024/02/23 23:53

How to solve "Emoji not displayed" issue in Slack

Slack is common chatting tool for IT engineers. In Slack, we can use Emoji icons. But in some issue case, Emoji icons were not displayed. Why were not they displayed ?So today I will introduce about 'How to solve "Emoji not displayed" issue in Slack'.

2024/02/21 22:33

Settings to check when VNC fails remote connection to Windows 10

VNC is a famous remote desktop connection software. A lot of people use VNC for remote access. But sometimes we faced some issue. For example, I used to be able to connect remotely, but now I can no longer connect. The destination server is running and VNC Server is also running. So what is the reason of connection failure ?So today I will explain about "Settings to check when VNC fails remote connection to Windows 10".

2024/02/19 22:56

How to fix Amazon Prime Video unavailable Error 7031

Prime video is Amazon's VOD service. It is a VOD service that Amazon Prime members can use. A lot of people viewed Prime Video in a variety of ways, including web browsers, TVs, and tablet devices. However, Prime Video sometimes causes errors like this. Video Unavailable We're experiencing a problem playing this video. For assistance, please go to www.amazon.com/dv/error/7031There is a link indicated in the error message. But even if I read the link page, I couldn't solve the issue. What should we do if this error message appears? Are there any way to solve it ?So today I introduce about "How to fix Amazon Prime Video unavailable Error 7031".

2024/02/18 22:51

Sites to check when you suspect a issue on Twitter

"Twitter" is a popular SNS for simple tweets.It is used all over the world and has a great influence in the SNS community. But sometimes we can't access Twitter. However, even if you can't connect it doesn't mean problem. How can I check if there is a problem or not ?So today, I will introduce about "Sites to check when you suspect a issue on Twitter".

2024/02/14 23:25

How to convert BigQuery column to array

BigQuery(BQ) is very useful for data analysis or processing. It is good at handling huge data. It returns summary result in short time. BQ has one useful data format array. It can handle multiple data like [1,2,3] in 1 row. But how can we create array data from column data. So today I introduce about "How to convert BigQuery column to array".

2024/02/12 22:37

How to get minus difference in BigQuery

BigQuery(BQ) is very useful for data analysis or processing. It is good at handling huge data. It returns summary result in short time. And also we can use BQ with very cheap price. Sometimes we want to compare data between 2 tables. For example, when we change some data processing program, we must check difference between previous result and modified one. But How can we get minus difference in BigQuery ?So today I introduce about "How to get minus difference in BigQuery".

2024/02/12 22:03

DateTime convert error between spreadsheet and BigQuery

BigQuery(BQ) is very useful for data analysis or processing. It is good at handling huge data. It returns summary result in short time. And we can use spreadsheet as data source of BigQuery. But you may get such kind of message when you try to select spreadsheet data. Error while reading table: test.datetime_sample, error message: Could not convert value to datetime. Row 1; Col 0. It seems like datetime error. But how can we solve it ? So today I introduce about "DateTime convert error between spreadsheet and BigQuery".

2024/02/12 21:15

How to use alternative column value instead of null in BigQuery

BigQuery(BQ) is very useful for data analysis or processing. It is good at handling huge data. It returns summary result in short time. But data is not always clean. Sometimes it contains NULL in specific column. In that case we should use another value. Then how can we use alternative value ?So today I introduce about "How to use alternative column value instead of null in BigQuery".

2024/02/12 16:28

How to get average, median, mode value in BigQuery

BigQuery(BQ) is very useful for data analysis or processing. It is good at handling huge data. It returns summary result in short time. And we want average, median, mode value when we analyze data. How can we get these values in BigQuery ?So today I introduce about "How to get average, median, mode value in BigQuery".

2024/02/12 14:48

Why are custom fields added to activities in Salesforce not reflected in the input window?

Salesforce has "Activity record" to record what kind of activities were done for leads and opportunities. It is a convenient function that allows you to record what kind of meetings and contacts you have with customers like a history. And you can add custom fields to activities. However, when We add custom fields to activities, the fields are not added to the activity input window for opportunities and leads. Even if the item is reflected in the ToDo layout, it will not be reflected in the Opportunity or Lead. Why is the added custom item not reflected in the input window? So this time, I will introduce about "Why are custom fields added to activities in Salesforce not reflected in the input window?".

2024/02/11 17:36

Why can't we save quick text in Salesforce shared folder ?

Salesforce has "quick text". "Quick text" is a function that assists character input, and it is a function that allows you to select and input a fixed phrase that has been registered in advance. It's a simple and convenient feature because you don't have to enter the same text over and over again. But if you create a quick text without any settings, only you can use it. In order for other people to use it, it is necessary to put the quick text in a shared folder, but even if you create a new one in the shared folder, Quick text cannot be created in a shared folder. Why is the shared folder not reflected? So this time, I will introduce "Why can't we save quick text in Salesforce shared folder ?".

2024/02/11 16:30

Save button is disabled in Salesforce Flow Builder

Salesforce has a "flow" that automatically executes a specific process. It is a convenient function that can automatically execute various processes, such as creating related child records when creating business negotiation records, sending emails after recording sales activities, and so on. However, when we try to change this flow, we can't press the save button. Why can't we save the flow? So today, I will explain about "Save button is disabled in Salesforce Flow Builder".

2024/02/11 15:28

Why can't we use quick text in Salesforce mobile app?

One of Salesforce's features is "quick text". "Quick text" is a function that assists character input, and it is a function that allows you to select and input a fixed phrase that has been registered in advance. It's a simple and convenient feature because you don't have to enter the same text over and over again. It's such a useful quick text. But it doesn't appear when we try to use it in Salesforce mobile app. We want to use quick text, but the quick text selection screen does not appear. Why is the quick text not displayed ?Is there a way to use quick text in the Salesforce mobile app? So this time, I will explain about "Why can't we use quick text in Salesforce mobile app?".

2024/02/10 21:03

Why we can't use long text area for custom field in Salesforce activity

Salesforce has "Activity record" to record what kind of activities were done for leads and opportunities. It is a convenient function that allows you to record what kind of meetings and contacts you have with customers like a history. And an activity can have multiple custom fields to fill out. It's convenient to separate the contents to be filled in for each category, but the item has a character limit of 255 characters, cannot use long text area. It does not appear as an option to select the data type of the item. Why doesn't the long text area appear? So this time, I will introduce about "why we can't use long text area for custom field in Salesforce activity".

2024/02/10 17:30

How to solve experience site login loop issue on Salesforce Sandbox

Salesforce has "Experience Site" as a function to create a website. It is a function that allows you to build a portal site for internal and external use, and you can also use Salesforce data. It's a pretty useful feature, but there are times when you can't login to the experience site even if you want to. Even if you try to log in to the Sandbox experience site created from the production environment, it will loop and you will not be able to log in. Why can't we log in to the experience site? Therefore, today, I will introduce about "How to solve experience site login loop issue on Salesforce Sandbox".

2024/02/10 11:34

The reason why Salesforce list view does not show data

Salesforce is a CRM (customer management system) and a web service used all over the world. Although it is a web service, it has a certain degree of customizability, and many companies use it for purposes other than sales. However, the some specifications of Salesforce are difficult to understand. For example, "list view search box doesn't work properly". Therefore, today I will introduce about "The reason why Salesforce list view does not show data" .

2024/02/08 19:46

How to fix "ls: command not found" error in Linux

When we use linux server like XSERVER through SSH connection, we usually use these commands like ls or vi. But one day your server would refuse your command, and you may see the error below. bash: ls: command not found What is root cause of this error. How to find root cause without commands like ls. So today I will introduce about how to fix "ls: command not found" error in Linux.

2024/02/07 22:46

How to calculate datetime in Python

Sometimes we would like to calculate datetime in Python. Then we search like "Python date time calculate". So today I introduce about "How to calculate datetime in Python".

2024/02/04 17:50

Why does decision tree make flat prediction?

When we want to predict something that has numeric value, we sometimes use AI model. Decision tree is one of AI model. Its process is light. So decision tree model is easy to use. But when you use decision tree model like RandomForest or XGBoost or LightGBM, sometimes it makes flat result. So today I will introduce about "Why does decision tree make flat prediction?".

2024/02/04 16:45

How to keep column order in case of concatenate pandas DataFrame

Pandas DataFrame is useful for data handling in Python. But when we concatenate DataFrame, sometimes column order changes. If column order is changed, it seems weird. If possible, we want to use original column order. So today I will introduce about "How to keep column order in case of concatenate pandas DataFrame".

2024/02/02 23:17

The reason why you can't input text in PyCharm

PyCharm is famous IDE of Python. But sometimes it refuses our text input. When we tried to input text in PyCharm, text is not displayed. Why does PyCharm refuse our text input? Today I will introduce about "The reason why you can't input text in PyCharm".

2024/02/01 23:00