Categories
Mastering Development

How to sort stacks within each ggplot’s facets?

Please help us sort the stacks in ascending order ! i.e. left facet seems to be in order but right side is not really sorted because 1.7 should have come at the right end. (please refer screenshot) similar but not exact queries How to control ordering of stacked bar chart using identity on ggplot2 Order […]

Categories
Mastering Development

Conversion failed when converting the varchar value ‘.’ to data type int

I have a query as below: SELECT activity_code, activity_name, Count(*) Total_Response, yearnumber, Cast(Avg(Cast(Isnull([response], 0) AS NUMERIC)) AS DECIMAL(10, 2)) [Ratings] FROM (SELECT code [Activity_Code], activityname [Activity_Name], enddt.yearnumber, CASE WHEN Isnumeric(asmt.userresponse) = 1 THEN asmt.userresponse ELSE 0 END [Response] FROM (SELECT userid, questionid, activityid, attemptenddateid, CASE WHEN Isnumeric(userresponse) = 1 THEN userresponse ELSE ‘0’ END AS […]

Categories
Apple Ask

Remove the “Legacy Software” and “Installations” lists of System Information

There are a couple of programs listed in Legacy Software in the System Information: Is it possible to remove those entries? They are all old apps I’ve uninstalled, so there is no need to keep those information. I already deleted all leftover of these apps located in Users/[home folder]/Library/Application Support & Library/Application Support and checked […]

Categories
Development

How can I find the largest increase in value of the elements of this list and then return the corresponding year and actual value it increased by

MIDYEAR_POPULATION = [(1971, 21962032), (1972, 22218463), (1973, 22491777), (1974, 22807969), (1975, 23143275), (1976, 23449808), (1977, 23725843), (1978, 23963203), (1979, 24201544), (1980, 24515667), (1981, 24819915), (1982, 25116942), (1983, 25366451), (1984, 25607053), (1985, 25842116), (1986, 26100278), (1987, 26446601), (1988, 26791747), (1989, 27276781), (1990, 27691138), (1991, 28037420), (1992, 28371264), (1993, 28684764), (1994, 29000663), (1995, 29302311), (1996, 29610218), (1997, […]

Categories
Development

How can I find the largest increase in value of the elements of this list and then return the corresponding year and actual value it increased by

MIDYEAR_POPULATION = [(1971, 21962032), (1972, 22218463), (1973, 22491777), (1974, 22807969), (1975, 23143275), (1976, 23449808), (1977, 23725843), (1978, 23963203), (1979, 24201544), (1980, 24515667), (1981, 24819915), (1982, 25116942), (1983, 25366451), (1984, 25607053), (1985, 25842116), (1986, 26100278), (1987, 26446601), (1988, 26791747), (1989, 27276781), (1990, 27691138), (1991, 28037420), (1992, 28371264), (1993, 28684764), (1994, 29000663), (1995, 29302311), (1996, 29610218), (1997, […]

Categories
Development

Dataframe with date difference between index value and column name in each cell

I have a dataframe with one column, called maturity_dates. I also have a DateTimeIndex, called simulationdates. I want to create a dataframe, where each cell is the simulationdates value minus the MAT_DATE. Additionally, I want the figure to be minimum 0, and represented in years. The code below does the job, but it is very […]

Categories
Development System & Network

Cpanel Error Logs: Timeout waiting for output from CGI script and WordPress: 500 internal error

Well, after transfering the dns server and applying a revert,we started to get a tons of 500 internal errors while using the admin panel (only in admin panel). After that i went to cPanel: Error Logs to see what is happening and saw this error: Timeout waiting for output from CGI script public_html/wp-admin/admin-ajax.php Timeout waiting […]

Categories
Development

Method returns and debugs as normal but prints out an extra unexpected output

So here is the situation, I have a supposed range of Automobile objects with a year data field associated with them. This application I am making calls for a method that breaks up the years by ranged segments. I think I got it to work as far as the production code is concerned but the […]

Categories
Development

Octave barh with colors based on third value

A is a 16×124 matrix with the values that plot in the bar chart. I guess the default is to have the colors associated with the index (1 to 124). The trouble I’m having is that I want each section of the bar chart to be color coded based on the corresponding value within matrix […]

Categories
Development

Finding specific text in pandas dataframe column

I have a dataframe with column containing references of papers and I want to look for any reference repeated in the whole column for all references. Here are the some rows from dataframe: **cit2ref** **reference** **_id** 0 NaN All about depression: Diagnosis. (2013). Retrieved December 7, 2016, from All About Depression, http://www.allaboutdepression.com/dia_03.html Y17-1020 0 NaN […]