Tera Term is common SSH software. A lot of Windows users use Tera Term. When we try to make SSH connection with using TTL macro file. Sometimes we may face "Invalid host" error. Even the content of the TTL file is correct, it raises "Invalid host" error. Why does the error happen ? So today, I will introduce about "How to solve "Invalid host" error of Tera Term".

Recently AVIF image file format was created. It is highly compressed file and HDR supported. For example, Skeb service uses this file format. But because of new file format, some apps can't read AVIF image. If apps don't support AVIF files, we can't see images. Some people might want to convert AVIF to .jpeg or PNG. So today, I will introduce about "How to convert AVIF image file to JPEG or PNG file".

when using such Zoom. Change to full screen automatically when screen sharing It's nice to be able to see the screen shared by the other party by making it full screen, but it can be troublesome if you do it without permission. Is there a way to prevent it from going full screen? So, this time, I will explain "How to avoid automatic full screen when someone shares the screen on Zoom".

Salesforce has a feature called "Experience Site". This is a website building function that allows you to create a website using a pre-installed builder. There is also a login function, and you can display tiles and lists using object records in Salesforce. In order to control records and columns, we can use List View in Salesforce. However, the list view may not be reflected well on the experience site. Even though I added a filter condition to the list view, when some users log in, the records before the filter was added are visible. Why isn't it reflected in some users even though I added a filter? Therefore, today I will introduce about "The reason why filter condition changes in Salesforce list view not reflected on the experience site".

Linux is common for server usage. In initial settings of Linux server like Ubuntu, sometimes you fail SSH connection. Why did it refuse connection ? What should we do to connect Linux server ? So today, I will introduce about "What you should check when SSH connection is refused in Linux".

Pandas is very useful to handle table data. In table data, sometimes it contains None data. In that case we would like to remove None from specific column. So how can we remove None ? Today I will introduce about "How to remove none from pandas DataFrame".

pandas.DataFrame is useful to handle table format data. With using pandas, we can import CSV or Excel data and join them with common key column. And sometimes you want to get all combination data without any join condition. But how can we get such all combination data. So today I will introduce about "How to get cross join with pandas.DataFrame".

You might see such an error when you tried to do logical operation. ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). Why does such kind of error happen ? How can we solve it ？So today I will introduce about "The reason of "ValueError: The truth value of a Series is ambiguous" in NumPy or Pandas".

pandas.DataFrame is useful to handle table format data. We can import CSV or Excel data into dataframe and summarize it. Then sometimes we want to know dataframe content in progress. So we will do like following. print(df) We will use print. But it omits rows and columns when it has a lot of rows and columns. If important parts are omitted, it is hard to test program. How can we print all rows and columns ?So today I will introduce about "How to print all rows and columns in pandas.DataFrame".

pandas.DataFrame is useful for handling table data. With using it, we can handle CSV or Excel data as table data. Sometimes table data has boolean data like True/False. In order to reverse boolean values, what should we do ?So today I will introduce about "How to get inverse boolean value in pandas.DataFrame".

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 . […]

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".

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'".

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"'.

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".

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".

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".

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".

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".

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".