TopMiniSite
-
3 min readTo get types from an F# assembly using PowerShell, you can use the Add-Type cmdlet to load the assembly into your session. Once the assembly is loaded, you can use the Get-ChildItem cmdlet to explore the types contained within the assembly. You can also use the Get-Member cmdlet to inspect the properties and methods of each type. Additionally, you can use the New-Object cmdlet to create instances of the types within the assembly and interact with them programmatically.
-
3 min readTo ignore or convert "\n" in a CSV file using Pandas, you can read the file into a Pandas DataFrame and then manipulate the data accordingly. One way to handle "\n" characters is by using the replace() method to replace them with an empty string or any other desired character.You can read the CSV file into a DataFrame using the read_csv() function in Pandas: import pandas as pd df = pd.read_csv('file.
-
4 min readTo access single columns in pandas using a for loop, you can iterate over the column names and then use the column name to extract the column data. You can do this by first getting the list of column names using df.columns, and then iterating over each column name to access the column data using df[column_name].
-
5 min readTo convert JSON data from a URL into a pandas dataframe, you can use the json() method of the requests library to fetch the JSON data from the URL. Then you can use the pandas library to read the JSON data into a dataframe using the pd.read_json() function. Make sure to handle any errors that may occur during the process, such as network connectivity issues or invalid JSON data.
-
4 min readTo save URL output into a file in PowerShell, you can use the "Invoke-WebRequest" cmdlet to fetch the content of the URL, and then use the ">" operator to redirect the output to a file. Here's an example of how to do it: $webContent = Invoke-WebRequest -Uri "https://www.example.com" $webContent.Content > "output.txt" In this example, the content of the URL "https://www.example.
-
3 min readTo change the timestamp format from yyyy-dd-mm to yyyy-mm-dd in pandas, you can use the pd.to_datetime() function to convert the timestamp column to datetime format. Then, you can use the dt.strftime() function to specify the desired date format ("%Y-%m-%d") and apply it to the datetime column. This will change the timestamp format from yyyy-dd-mm to yyyy-mm-dd in pandas.
-
3 min readTo run two commands simultaneously in PowerShell, you can use the Start-Process cmdlet with the -NoNewWindow parameter. This allows you to run both commands in separate windows without waiting for the first command to finish before starting the next one. Here's an example of how you can do this: Start-Process -NoNewWindow cmd.exe "/c command1" Start-Process -NoNewWindow cmd.
-
4 min readTo process 50 million rows quickly in pandas, it is important to optimize your code and use efficient techniques. One approach is to use vectorized operations instead of looping through each row individually, as this can significantly improve performance. Additionally, consider using the built-in functions in pandas, such as groupby, apply, and agg, as they are optimized for speed.Another tip is to avoid unnecessary operations and only select the columns that you need for analysis.
-
5 min readTo sort a multi dimensional array in PowerShell, you can use the Sort-Object cmdlet with the -Property parameter. This parameter allows you to specify which property or properties to sort the array by. You can also use the -Descending parameter to sort the array in descending order. Additionally, you can use the .Sort() method on the array to sort it in place. Sorting a multi-dimensional array in PowerShell allows you to organize your data in a way that makes it easier to work with and analyze.
-
2 min readTo create a DataFrame from two Pandas Series, you can simply pass the Series objects as a dictionary to the DataFrame constructor. For example, if you have two Series called 's1' and 's2', you can create a DataFrame like this: import pandas as pd # Create two Series objects s1 = pd.Series([1, 2, 3, 4, 5]) s2 = pd.Series(['a', 'b', 'c', 'd', 'e']) # Create a DataFrame from the two Series df = pd.
-
6 min readTo split and sort a dataframe into multiple ones in pandas, you can use the groupby function along with the sort_values function. First, you can group the dataframe by a specific column or multiple columns using the groupby function. Then, you can use the sort_values function to sort the data within each group based on a specified column. This will allow you to split the dataframe into multiple smaller dataframes based on the grouped criteria and have them sorted accordingly.