How to solve "Invalid host" error of Tera Term
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".
How to convert AVIF image file to JPEG or PNG file
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".
How to avoid automatic full screen when someone shares the screen on Zoom
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".
The reason why filter condition changes in Salesforce list view not reflected on the experience site
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".
What you should check when SSH connection is refused in Linux
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".
How to remove none from pandas DataFrame
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".
How to get cross join with 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".
The reason of "ValueError: The truth value of a Series is ambiguous" in NumPy or Pandas
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".
How to print all rows and columns in pandas.DataFrame
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".
How to get inverse boolean value 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".
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 . […]
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 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'".
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"'.
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".
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".
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".
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".
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".
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".
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'.
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".
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".
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".
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".
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".
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".
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".
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".
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?".
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 ?".
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".
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?".
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".
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".
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" .
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.
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".
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?".
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".
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".
How to wait input from keyboard in Python
I want my program to wait input text. Not only Python but also other program, you want it to wait input from keyboard. But what should we write to wait input. Today I will introduce about "How to wait input from keyboard in Python".
Open rolling window backwards in pandas
I can open rolling window forward.But how can I open it backwards ?With using pandas, sometimes you may want to open window not forward but backwards.But how can we Open rolling window backwards.Today I will introduce about "How to open rolling window backwards in pandas".
「ブログリーダー」を活用して、karasanさんをフォローしませんか？
指定した記事をブログ村の中で非表示にしたり、削除したりできます。非表示の場合は、再度表示に戻せます。
画像が取得されていないときは、ブログ側にOGP(メタタグ)の設置が必要になる場合があります。
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".
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".
