I have a big dataset in excel that I have imported in r and now I want to separate years, months and days
What is best captcha service these days?
On my wordpress site i have page built with Visual Composer plugin, but from last few days the page’s content automatically gets deleted and replaced by “N;”
I don’t think its a hack, it just seems to be happening only with this one page.
The description of the aarakocra includes a section called Sky Wardens containing interesting sentences such as:
They can spend hours in the air, and some go as long as days, locking their wings in place and letting the thermals hold them aloft.
In general, this section implies that an aarakocra is able to fly for days on end given the right environmental conditions. This is an interesting trait, and a plausible one, as there are indeed real-life birds who spend almost their entire lives airborne.
However, looking at the racial traits, it’s not obvious how an aarakocra player character could accomplish such feats. For one thing, it seems that an aarakocra player would still need to land for 8 hours each day in order to take a long rest. That by itself is not terrible, since they could opt to skip a long rest and risk exhaustion from sleep deprivation in order to keep flying. Probably the bigger hurdle is the forced march rules:
For each additional hour of travel beyond 8 hours, the characters cover the distance shown in the Hour column for their pace, and each character must make a Constitution saving throw at the end of the hour. The DC is 10 + 1 for each hour past 8 hours. On a failed saving throw, a character suffers one level of exhaustion.
So it seems that an aaracokra that attempts to remain in flight for even 24 consecutive hours will face 16 constitution saving throws with DCs ramping up from 11 to 26, and failing too many of these saving throws will exhaust them to the point that they fall out of the sky.
So, am I missing some mechanic or aspect of the aarakocra’s racial traits that allows them to remain in flight for extended periods of time, or to the mechanics of the race simply not live up to the description?
Leomund’s secret chest is a spell that lets the caster hide a very expensive chest in the Ethereal Plane. However, its drawback is that after 60 days, there is a chance the spell ends. If the spell ends while the chest is in the Ethereal Plane, it’s lost forever.
My question is, where does the 60 day counter start? Is it from the moment of casting, so that you need to re-cast the spell every 60 days? Or do you just need to recall the chest every 60 days to check on its contents?
What is the going rate for forum posters these days?
I need to hire some forum posters to help a new site take off.
What are forum posters charging these days?
Its a mixed forum, no specific niche,
so you can post whatever you want, except porn and adult content.
Travel, vacations, finance, news, anything is ok.
But posts should be distributed between 10-20 accounts at least. All should not be from same account.
What would a forum poster charge for this?
I have just come back from a nightmare. The nightmare consisted of me having previously installed PostGIS into my PostgreSQL database according to the installation instructions by PostGIS.
This made it live in the “public” schema, with all my stuff, polluting the functions and adding an internal table among mine.
With a lot of trouble, I finally was able to create a “PostGIS” schema, into which I reinstalled PostGIS, then recreated all the columns the “DROP CASCADE” had removed (because they used a PostGIS type).
Now, I started getting errors because internal queries made by PostGIS did not quote the schema, but simply took my “PostGIS” string and turned it into:
... FROM PostGIS.test = blabla
Since this is invalid syntax, it failed. And I was forced to go through the ordeal of renaming the PostGIS schema into “postgis”, just so that their internal, broken queries would work.
But it doesn’t end there. Now I started getting other errors, because renaming the schema did not change all kinds of internal references, so it would still refer to “PostGIS” even though both the extension and the schema were now “postgis”…
I eventually (today) did it all over again from scratch and again recreated my columns manually and filled them up with all the data.
I see this all the time where software developers cut corners and don’t test their stuff for any other situation than what specifically they use/do, so whenever somebody does things differently (or, as I would call it: correctly!), they (the users) are the ones who suffer because of the developers’ ignorance/laziness.
And yes, I know it’s free software blabla, I didn’t pay for it so they can waste as much of my time and energy as they please, and I can “submit patches” to fix it (because I can’t wait to dig into their internal code and figure out how to make that change to fix their software…), etc. I’ve heard it all many times before. I know the excuses.
The fact remains that not only PostGIS but just about anything I ever use just breaks down immediately in horrible ways unless you use them in an extremely specific manner, and I hate this lack of care to “details”. In this case, I would say it’s a fundamental error to not properly quote identifiers such as schemas, table names and column names, but of course this will fall on deaf ears as any criticism of anything always does, no matter how warranted and serious.
currently, I have this table:
CREATE TABLE `plant_data` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `plant_id` BIGINT(20) UNSIGNED NOT NULL, `temperature` DECIMAL(5,1) UNSIGNED NOT NULL, `light` SMALLINT(5) UNSIGNED NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), )
with the following example data:
INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1623, 14, 22.2, 35, '2020-02-16 09:00:06', '2020-02-16 09:00:06'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1622, 5, 22.8, 33, '2020-02-16 09:00:06', '2020-02-16 09:00:06'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1621, 14, 22.8, 36, '2020-02-16 08:00:07', '2020-02-16 08:00:07'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1620, 5, 23.3, 33, '2020-02-16 08:00:07', '2020-02-16 08:00:07'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1619, 14, 23.1, 36, '2020-02-15 07:00:11', '2020-02-15 07:00:11'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1618, 5, 23.8, 34, '2020-02-15 07:00:11', '2020-02-15 07:00:11'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1617, 14, 24.4, 38, '2020-02-15 06:00:09', '2020-02-15 06:00:09'); INSERT INTO `plant_data` (`id`, `plant_id`, `temperature`, `light`, `created_at`, `updated_at`) VALUES (1616, 5, 24.6, 34, '2020-02-15 06:00:09', '2020-02-15 06:00:09');
I want to get the average values of the last X days as one row for each day. I could do it with X querys for each day like
SELECT plant_id, avg(temperature) FROM plant_data WHERE created_at >= '2020-02-16 00:00:00' AND created_at <= '2020-02-17 00:00:00' GROUP BY plant_id;
But I want to know, if it is possible to get the data with one query to get a result like this:
+----------+------------------+------------+ | plant_id | avg(temperature) | day | +----------+------------------+------------+ | 5 | 24.58000 | 2020-02-16 | | 14 | 24.42000 | 2020-02-16 | | 5 | 23.58000 | 2020-02-15 | | 14 | 23.42000 | 2020-02-15 | +----------+------------------+------------+
Would be nice if someone has a good idea for doing this to save me query time.
Just curious if there’s some ingenious way to set up several glyph of warding spells to activate simultaneously. Some of them cast teleportation circle, Some of them to receive glyph of warding and store a casted teleportation circle.
In this way in 365 days you can enjoy a cheap efficient circle with the mats of but a few while exploring?
Little background Let’s say you fly from the United States to Japan and suppose you leave the United States on Tuesday morning. Because you’re travelling west, the time advances slowly thanks to time zones and the speed at which your aeroplane flies. But as soon as you cross the international dateline, it’s suddenly Wednesday.
Below image from google flight, which is +2 means taking 2days gap. this +2 doesn’t make a sense for me.